Splitting Text strings in one cell

Giganews Newsgroups
Subject: Splitting Text strings in one cell
Posted by:  Wardy1 (Wardy1.2802qm_1147950601.4731@excelforum-nospam.com)
Date: Thu, 18 May 2006

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?action=getinfo&userid=27104
View this thread:http://www.excelforum.com/showthread.php?threadid=543247

Replies