| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am trying to change Smith, John to John Smith
The tricky part about this is the that it must be done in only 2 cells, all
of the example given in the Excel tutorials are using one cell for each name, one for the first and one for the last. That however, does not help me. I must convert these names in singles cells like such From:CELL1--[Smith, John] To:CELL2--[John Smith]. CAN SOMEONE HELP ME PLEASE....1000 Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How to change ALL CAPS to Initial Caps only? | Excel Worksheet Functions | |||
| Find function | Excel Worksheet Functions | |||
| Cell Change Color - Need Help | New Users to Excel | |||
| Pivot Table Zero Value | Excel Discussion (Misc queries) | |||
Threaded Mode
