Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In Excel- change the order of a name? Bill Gates to Gates, Bill
What is the formula for changing the order of a name?
|
#2
|
|||
|
|||
Assume your name is in cell A1:
=CONCATENATE(RIGHT(A1,LEN(A1)-SEARCH(" ",A1)),", ",LEFT(A1,SEARCH(" ",A1))) -- Regards, Dave "arnold36" wrote: What is the formula for changing the order of a name? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
On a excel protected worksheet, how do I change the tab order? | Excel Worksheet Functions | |||
Excel gets subtotals out of order using multiple sorts and subtot. | Excel Discussion (Misc queries) | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel |