If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Name conversion
I have a spreadsheet that is updated by multiple users.
When they enter their names they enter it in the format (first_name Last_name). Does anyone know how I could convert this entry to the format (Last_name,first_name)? I would really appreciate your help. |
#2
|
|||
|
|||
Name conversion
Assuming your first entry is in A1 and your names are always in the format
you described, you can use the following: =MID(A1,FIND(" ",A1)+1,999) & ", " & LEFT(A1,FIND(" ",A1)-1) and fill down to the end of your list. /i. wrote in message ... I have a spreadsheet that is updated by multiple users. When they enter their names they enter it in the format (first_name Last_name). Does anyone know how I could convert this entry to the format (Last_name,first_name)? I would really appreciate your help. |
Thread Tools | |
Display Modes | |
|
|