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)
