TextToColumns question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Probably best to use this idea
http://www.cpearson.com/excel/FirstLast.htm

--
Don Guillett
SalesAid Software
(e-mail address removed)
Arch said:
I want to split full name column into three columns, first, middle, last.
Click to expand...
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?
 
No need to multipost


--
Don Guillett
SalesAid Software
(e-mail address removed)
Arch said:
I want to split full name column into three columns, first, middle, last.
Click to expand...
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?
 
Back
Top