Monday 24 March 2014

Formula Left and Right


Formula Left and Right



 ABC
2Ameen AkbarAmeenAkbar

Spreadsheet Formulas
CellFormula
B2=LEFT(A2,FIND(" ",A2)-1)
C2=RIGHT(A2,LEN(A2)-FIND(" ",A2))

another formula
B2: =LEFT(A2,FIND(" ",A2,1)-1) and this one in C2: =RIGHT(A2,LEN(A2)-FIND(" ",A2,1)).
Posted by at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)