| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Text to Columns Help! First Name MI Last Name
Hi everyone,
I have a column of proper names, some of which have middle initials and some of which do not. I am trying to get them into columns of | first name | MI | Last Name |. The problem is that excel seperates them into three columns with the last name in the middle column for people without middle initials, and the last name in the third column for people with middle initials. I would appreciate any help you excel experts could give me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I unwrap text to columns? | Excel Discussion (Misc queries) | |||
| Text to columns - one way street? | Excel Discussion (Misc queries) | |||
| How do I convert from text to columns automatically on import? | Excel Discussion (Misc queries) | |||
| comparing columns of text (cross-searching) | Excel Discussion (Misc queries) | |||
| Text to columns | Excel Discussion (Misc queries) | |||
Threaded Mode
