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)))

0 comments:
Post a Comment