Excel Formula for pulling name from full name

Here is something I have used before and needed to do again today. Within Excel I had a column with full name Joe Smith, and I needed to separate the two into their own fields.

For each new field I used the following formula:

Get the first name in Column C from Full name in Column A

[code[=LEFT(A1,FIND(” “,A1,1)-1)[/code]

 Get Last name in Column D from Full Name in Column A

[code]=RIGHT(A1,LEN(A1)-FIND(” “,A1,1))[/code]

I know I will need this again in the future so .. consider it logged

Tagged , . Bookmark the permalink.

Comments are closed.