Hi all.

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

My current solution is to first search and replace the space in the text with a hyphen then do the text to columns. So far I have the macro 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't remember exactly how I did it) but then I found it was reversing the day and the month when separated.

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

TIA