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!!