Hi Guys,

I have some data in one colum that contains a full name (first *space*
last)

I want to split the names into two colums, and i know that you can do
it via text to colums, but it dosent see the space correctly..

If the names are seperated by two spaces it does it correctly.. but it
wont see the sigle space as a delimiter it just keeps the data in the
one (original) colum...

Any ideas..

Cheers


--
blander
------------------------------------------------------------------------
blander's Profile: http://www.excelforum.com/member.php...o&userid=36486
View this thread: http://www.excelforum.com/showthread...hreadid=568945