Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi All:
I have a list of names stored in MS Excel. Last name is in first column but first name and middle initial are in second column. The file looks like: Last name First Name West Joe Hellygard David J. Huang Nancy H. Now I want to separate first name and middle initial and move middle initial to third column. The problem is that the length of first name is not same. Definitely I cannot use Text to Column. Any help or suggestions are very appreciated. Charles |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
First name, Middle Initial | Excel Discussion (Misc queries) | |||
Stripping Middle Initial from a Name | Excel Worksheet Functions | |||
Extract middle initial | Excel Discussion (Misc queries) |