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