MrExcel Publishing
Your One Stop for Excel Tips & Solutions

proper name


Posted by Carla Barnes on October 12, 2001 7:47 AM

When I pull information from our main DMS and dump into excel my customer name colum comes over as:
Smith,John. I want to flip this info to: John Smith

how is this done


Posted by Aladin Akyurek on October 12, 2001 8:31 AM

Carla,

Supposing that the first name to flip is in A1,

in B1 enter: =TRIM(RIGHT(A1,LEN(A1)-SEARCH(",",A1)-1)&" "&LEFT(A1,SEARCH(",",A1)-1))

Aladin

=========

:When I pull information from our main DMS and dump into excel my customer name colum comes over as:

Posted by Dan on October 12, 2001 8:33 AM

Do you want "John Smith" in one cell, or split up in a first name cell and last name cell?

Posted by gregc on October 12, 2001 8:45 AM

Here is a formula that you can put into a cell next the one with the names and copy and paste special to put the correct name in.
=RIGHT(a1,LEN(a1)-FIND(",",a1,1)) & " " & LEFT(a1,FIND(",",a1,1)-1)

Posted by gregc on October 12, 2001 8:47 AM

Here is a formula that you can put in the cell next to to the names and just copy and paste special into the original cell.

=RIGHT(a1,LEN(a1)-FIND(",",a1,1)) & " " & LEFT(a1,FIND(",",a1,1)-1)