Hi, i have about 300 cells in column A that contain data like:
KILMARNOCK SEPTEMBER 26/9/05
WINKINGTON OCTOBER 3/10/05
Theres no commas to seperate them, but i need to keep the name, eg Kilmarnock in cell A. And put the date into cell B. The name of the month is not necessary to keep.
Help, im stumped!!
Bookmarks