Hi all.

I have data imported from a csv file where one column (B) contain
cells with text and date in the format of "XXXX dd/mm/yyyy". Originall
was using text to columns to split these without a problem, using th
space as the separator. But recently I've been coming across some wher
there is a space inside the text which is causing problems.

My current solution is to first search and replace the space in th
text with a hyphen then do the text to columns. So far I have the macr
seaching for and replacing 15 different text entries.

Just wondering if anyone had an easier way to do this?

I used to count back a fixed number of characters from the right (can'
remember exactly how I did it) but then I found it was reversing the da
and the month when separated.

NOTE: My current method works, just looking for a more efficient way o
doing it.

TI

--
Mark
-----------------------------------------------------------------------
Mark K's Profile: http://www.excelforum.com/member.php...fo&userid=1411
View this thread: http://www.excelforum.com/showthread.php?threadid=57376