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
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..