|
|
||||||
|
#1
09-29-05, 05:58 PM
|
|
|
|
|
What is the formula for changing the order of a name?
|
|
|
|
#2
09-29-05, 06:05 PM
|
|
|
|
|
Assume your name is in cell A1:
=CONCATENATE(RIGHT(A1,LEN(A1)-SEARCH(" ",A1)),", ",LEFT(A1,SEARCH(" ",A1))) |
|
|
| Similar Threads | |
| Bill Gates and Father on Gates Growin' Up Charley Rose 12:30PM Eastern 4/29 Bill Gates and Father on Gates Growin' Up Charley Rose 12:30PM Eastern |
|
| OT: Bill Gates without XP SP2??? I know this is off topic but I had to say it out loud to someone... I just saw Bill Gates on CNN where he said that his 8 year old daughter suffers from the same problems on... |
|
| Wow bill gates? his picture is on the frontpage of technet. I must say he is looking very sexy. Do you agree? |
|
| Microsoft Bill Gates simulator simulates Bill Gates !!!! Everyone needs a little Bill Gates at home! |
|
| Bill Gates gets to be Knight Commander of the Order of the British Empire. Go away, Bill. I wish you stay as far away as possible. KB xbill Doug Laidlaw wrote: [..] |
|
|
All times are GMT. The time now is 09:07 PM. | Privacy Policy
|
In Excel- change the order of a name? Bill Gates to Gates, Bill