only by using a formula, it will always split on your first space if
that is the character you are spliting on. you could look at the mid
function combined with the search function to try and be more
specific.

You have not told us your logic in spliting so it is difficult to be
more helpful

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=563861