Home |
Search |
Today's Posts |
#1
|
|||
|
|||
change lname, fname to fname last name
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?? |
#2
|
|||
|
|||
if your data starts in cell A1:
=TRIM(RIGHT(A1,LEN(A1)-SEARCH(",",A1,1)) & " " & LEFT(A1,SEARCH(",",A1,1)-1)) "Al Wills" wrote: 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?? |
#3
|
|||
|
|||
Hi!
Try this: A1 = Smith, John =MID(A1,FIND(",",A1)+2,255)&" "&LEFT(A1,FIND(",",A1)-1) Returns: John Smith Biff "Al Wills" <Al wrote in message ... 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?? |
#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 "JMB" wrote: if your data starts in cell A1: =TRIM(RIGHT(A1,LEN(A1)-SEARCH(",",A1,1)) & " " & LEFT(A1,SEARCH(",",A1,1)-1)) "Al Wills" wrote: 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?? |
#5
|
|||
|
|||
anoher way use -data text to columns , delimiter=, (comma) and then
concantenate B1 and A1 you can do a macro on this. Al Wills wrote in message ... Hi JMB, Not quite, I still get lastname, firstname lastname ~ Thanks a lot though, the post from Biff worked fine! Thanks a lot! Al "JMB" wrote: if your data starts in cell A1: =TRIM(RIGHT(A1,LEN(A1)-SEARCH(",",A1,1)) & " " & LEFT(A1,SEARCH(",",A1,1)-1)) "Al Wills" wrote: 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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change macro text with another macro? | Excel Discussion (Misc queries) | |||
How do I get the font color to change automatically depending on | Excel Discussion (Misc queries) | |||
How do I link two cells as to allow me to change the value in eit. | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) |