Time pass to be honest,may work as a reference later,I am not sure.
Friday, March 27, 2015
Separate Firstname Lastname in Excel
The first column/first row(A1) has the name for example Sourav Bhattacharya. For the firstname B1 should have the formula like =LEFT(A2,(FIND(" ",A2))) For the last name in C1 the formula should be like =RIGHT(A2,(LEN(A2)-(FIND(" ",A2))))
No comments:
Post a Comment