Hi Group,
I have few sheets with col containing data " 123 4567"
I want this to be split in 2 dif col where space occurs.
sometimes there are 4 digits in first set like "1234 5678"
Any help would be apprecited.
Thanks
Sazi

--
sazi
-----------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...nfo&userid=635
View this thread: http://www.excelforum.com/showthread.php?threadid=57088