Hello:
Please refer to attached file.
I need to seperate out the first name and last name as shown in Column C and D without middle initial.
Let me know if you have any questions.
Thanks.
Hello:
Please refer to attached file.
I need to seperate out the first name and last name as shown in Column C and D without middle initial.
Let me know if you have any questions.
Thanks.
In C2:
=LEFT(A2,FIND(" ",A2)-1)
In D2:
=IF(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))=1, MID(A2,FIND(" ",A2)+1, LEN(A2)), MID(A2,FIND(" ",A2,FIND(" ",A2)+1)+1, LEN(A2)))
Bernie Deitrick
Excel MVP 2000-2010
F2 =LEFT(A2,SEARCH(" ",A2,1)) and drag down.
G2 =IFERROR(RIGHT(A2,LEN(A2)-SEARCH(" ",A2,SEARCH(" ",A2,1)+1)),RIGHT(A2,LEN(A2)-SEARCH(" ",A2,1))) and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hello:
Thanks to both of u
Riz
An alternative solution is with Power Query. Here is Mcode
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks