Hi all,
if anyone has got an answer to this I'd be greatfull,

The data in the cell currently looks like this;

52 Joe Blogg Street Sheffield S2 5TG

I want to apply a formula to split the address into different columns,
of course the address changes every time thus so do the position of the
spaces.

Cheers
R


--
Wardy1
------------------------------------------------------------------------
Wardy1's Profile: http://www.excelforum.com/member.php...o&userid=27104
View this thread: http://www.excelforum.com/showthread...hreadid=543247