Microsoft Excel String Functions Excel String Functions Lecture Slide Notes Online Tutorial Handouts Excel 2010 with Example Excel 2012
Cell A1 => Hisham---Malik
Cell B1 => =Substitute(A1,”-”,” “) => Hisham Malik
Cell C1 => =Search(“ “,B1) => 7
Cell D1 => =Left(A1, C1) => Hisham
Cell E1 => =Len(A1) => 14
Cell F1 => =Right(B1, E1-C1) => Malik
Cell G1 => =Trim(D1) => Hisham
Cell H1 => =Trim(F1) => Malik
Cell A1 => Hisham---Malik
Cell A2 => Trim(Left(Substitute(A1,”-”,” “), Search(“-“,A1)))
Cell A3 => Trim(Right(Substitute(A1,”-”,” “), Len(A1)-Search(“-“,A1)))
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQfUtSqnG2syIJZ_nLR2uPAx2BEqGESKOcXCUO9Vj7rQPVl4e7ILS15gaEB8LXuq1DzPOqpqH3S7HWqdSg0r5f-1gD3jzjcvsQjpxyQu_xGJzAsJMvPzdv57wUKTNIPr3y8RPLiXC8Hw/s200/PowerPoint-Lectuers+Slide+Usman+academy.png)
0 comments:
Post a Comment