TextToColumns question

[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.

 

[Don Guillett]

Probably best to use this idea
http://www.cpearson.com/excel/FirstLast.htm

--
Don Guillett
SalesAid Software
(e-mail address removed)

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?

 

[Don Guillett]

No need to multipost


--
Don Guillett
SalesAid Software
(e-mail address removed)

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?