Forum Discussion
Solved
Last Name, First name to First Name Last Name,
This is probably pretty basic, but I need to convert (CONCAT?) a column of names from (Last Name, First name) to (First Name Last Name,). Thanks, in advance!
Ex" A2 = BOND, JAMES
use: =RIGHT(A2,LEN(A2)-FIND(", ",A2))&" "&LEFT(A2,FIND(", ",A2)-1)
to get JAMES BOND
place formula only beside cells with commaex: BOND JAMES
use: =RIGHT(A2,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)
pls see attached file
So, I have a column with Last, First in most of the cells, but not all & I want to create a column with First Last, from the cells with commas & leave the rest alone. This newb needs help. LOL
Ex" A2 = BOND, JAMES
use: =RIGHT(A2,LEN(A2)-FIND(", ",A2))&" "&LEFT(A2,FIND(", ",A2)-1)
to get JAMES BOND
place formula only beside cells with comma
ex: BOND JAMES
use: =RIGHT(A2,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)
pls see attached file
- Thank you, my friend.
- glad I helped..