I have a series of entries in Column A like this:

28 December WH SMITH GB LICHFIELD 28 December 4.98
30 December TESCO STORE 2842 GB CARDIFF 30 December 33.36
31 December ASDA PETROL- UPT 4170 GB PEMBROKE 31 December 32.50
02 January ICELAND GB NEWPORT 02 January 6.00

..... and I want to split the data across 4 columns e.g. B:E which would be
Date, Name, Date2, Amount.

There is nothing in the text string I can use as a delimiter so I need to
build a formula. I've tried using Left and Right to at least split out the
first date and amount but I'm struggling as even these strings are of
different lengths.

Please could someone help me with formulas which would work for each of the
4 sections in the string.

Many thanks in anticipation