I have around 1500 address in an excel file. Each address is in a single cell such as:-
3 Carlisle Road, London, EW1 2CT.
I need each part of the address placed in it's own cell.
So the above would be:-
3 Carlisle Road in cell 1
London in cell 2
EW1 2CT in cell 3