TextToColumns question

A

Arch

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

Don Guillett

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.
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?
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top