Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I switch names around in excel?
Example it says Doe,John and I want it to say John Doe
|
#2
|
|||
|
|||
If Doe,John is in Column A insert a new Column B and enter
=RIGHT(A1,FIND(",",A1,1))&" " &LEFT(A1,FIND(",",A1)-1) The just Copy the Entire Column B and Edit | Paste Special | Values over Column A. "Erin" wrote: Example it says Doe,John and I want it to say John Doe |
#3
|
|||
|
|||
Nevermind. It worked for Doe, John but doesn't work for a different name I
tried. It's probably not the easiest way but you could use Data | text to column | Delimited | comma to put it into Columns A and B then use = B1&" "&A1 and copy it down. "ww" wrote: If Doe,John is in Column A insert a new Column B and enter =RIGHT(A1,FIND(",",A1,1))&" " &LEFT(A1,FIND(",",A1)-1) The just Copy the Entire Column B and Edit | Paste Special | Values over Column A. "Erin" wrote: Example it says Doe,John and I want it to say John Doe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Function to List an Excel Workbook's Sheet Names | Excel Discussion (Misc queries) | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Deleting Names in Excel 2003 | Excel Discussion (Misc queries) |