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

No need to multipost


--
Don Guillett
SalesAid Software
[email protected]
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?
 
Top