Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

Excel: Extract Firstname and Lastname from FullName

No comments
While looking at the scoreboard of the recently concluded game of the Laker versus Denver (Where Lakers won it by 2 points). I wondered how can I separate the player's fullname into firstname and lastname using Excel, if I only have the fullname column.

So after some experiments, and of course googling. I derived a solution given that A column contains the full names.

1. To get the firstname, I used the formula =LEFT(A1,FIND(" ",A1)-1)
2. To get the lastname, I used the RIGHT function to derive to =RIGHT(A1,LEN(A1)-FIND(" ",A1))


The output should look like the one below.

Excel: Extract Firstname and Lastname from FullName

To understand it better, please download the excel sample for this tip

No comments :

Post a Comment