Splitting Text strings in one cell

[Wardy1]

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

[CLR]

First us a copy for testing......and make sure there are several blank
columns to the right of your data column, then

Data > TextToColumns > Delimited > Next > check "space" as the
delimiter.....> Next > Finish

Vaya con Dios,
Chuck, CABGx3



"Wardy1" wrote:

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