Forum Discussion
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
11 Replies
For the static data Flash Fill https://support.office.com/en-us/article/using-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7 works fine if you are on Excel 2013 or later. Just start typing in first couple of cells, Flash Fill will do the rest
If you add more data select range in column B and click Fill->Flash Fill in ribbon
Mr. Baklan
good info..
thanks..
- PS I need to skip cells that have no commas.
- pls place some samples of output you need in the file I sent.
thanksBest response - so far - I'm hoping ;-)
pls see attached file
thanks..
- 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 commaex: BOND JAMES
use: =RIGHT(A2,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)
pls see attached file
- or you can use =concatenate(B2," ",A2)
