| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to switch two data cells ?
I LOVE this forum. Very helpful.
In Excel 2007, I've got 2 columns of data... FirstName LastName Joe Smith Mary Jones but SOME of the data are now in the format... Doe, John I want them all like... John Doe How can I go thru the columns and... Find any COMMAs in the FirstName column (that is actually a LastName), Anytime there is a comma, Delete the comma, Move the JOHN to the Previous column, and Move the SMITH to Next column. If it takes several steps... no problem. Thanks very much, people. Mark246 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Switch X & Y axis' when both data columns are dates (target/actual | Charts and Charting in Excel | |||
| Switch calculating cells off | Excel Discussion (Misc queries) | |||
| How to switch data between cells? | Excel Worksheet Functions | |||
| Is there a way to switch data between two cells? | Excel Discussion (Misc queries) | |||
| How do I switch arrow key commands for moving to other cells? | Excel Worksheet Functions | |||
Threaded Mode
