G Guest Jun 6, 2005 #1 I have work sheet with names listed as last name, first name, I would like to have them as just first name last name. Suggestions??
I have work sheet with names listed as last name, first name, I would like to have them as just first name last name. Suggestions??
G Guest Jun 6, 2005 #2 if your data starts in cell A1: =TRIM(RIGHT(A1,LEN(A1)-SEARCH(",",A1,1)) & " " & LEFT(A1,SEARCH(",",A1,1)-1))
if your data starts in cell A1: =TRIM(RIGHT(A1,LEN(A1)-SEARCH(",",A1,1)) & " " & LEFT(A1,SEARCH(",",A1,1)-1))
B Biff Jun 6, 2005 #3 Hi! Try this: A1 = Smith, John =MID(A1,FIND(",",A1)+2,255)&" "&LEFT(A1,FIND(",",A1)-1) Returns: John Smith Biff
Hi! Try this: A1 = Smith, John =MID(A1,FIND(",",A1)+2,255)&" "&LEFT(A1,FIND(",",A1)-1) Returns: John Smith Biff
G Guest Jun 6, 2005 #4 Hi JMB, Not quite, I still get lastname, firstname lastname ~ Thanks a lot though, the post from Biff worked fine! Thanks a lot! Al
Hi JMB, Not quite, I still get lastname, firstname lastname ~ Thanks a lot though, the post from Biff worked fine! Thanks a lot! Al
R R.VENKATARAMAN Jun 6, 2005 #5 anoher way use -data text to columns , delimiter=, (comma) and then concantenate B1 and A1 you can do a macro on this.
anoher way use -data text to columns , delimiter=, (comma) and then concantenate B1 and A1 you can do a macro on this.
