If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
TextToColumns question
I want to split full name column into three columns, first, middle, last. Some of my full names do not have middle initials. In that scenario, the last name goes in the middle column which I don't want. I am using TexToColumns. Is there a way to do it right?
Also I want to delete duplicate names. How do I do this ? Thanks. |
#2
|
|||
|
|||
TextToColumns question
Probably best to use this idea
http://www.cpearson.com/excel/FirstLast.htm -- Don Guillett SalesAid Software "Arch" wrote in message ... I want to split full name column into three columns, first, middle, last. Some of my full names do not have middle initials. In that scenario, the last name goes in the middle column which I don't want. I am using TexToColumns. Is there a way to do it right? Also I want to delete duplicate names. How do I do this ? Thanks. |
#3
|
|||
|
|||
TextToColumns question
No need to multipost
-- Don Guillett SalesAid Software "Arch" wrote in message ... I want to split full name column into three columns, first, middle, last. Some of my full names do not have middle initials. In that scenario, the last name goes in the middle column which I don't want. I am using TexToColumns. Is there a way to do it right? Also I want to delete duplicate names. How do I do this ? Thanks. |
Thread Tools | |
Display Modes | |
|
|