Split column on first space

[rexmann]

Hi

I have a spreadsheet pulled into excel with a list of clients. Unfortunately
the entire address appears in one cell and I want to pull the number details
out at the front. Example

13 Blackstock Road
135 Smithy Street
etc.

Is there a way of splitting at the first space (but not the other spaces)

kind regards

Rexmann

PS Using Excel 2003

 

[Gary''s Student]

We FIND the first space and then use RIGHT & LEFT:

In B1:

=LEFT(A1,FIND(" ",A1,1)-1)

In C1:

=MID(A1,FIND(" ",A1,1)+1,1000)

 

[rexmann]

Job done, thank you

Rexmann

We FIND the first space and then use RIGHT & LEFT:

In B1:

=LEFT(A1,FIND(" ",A1,1)-1)

In C1:

=MID(A1,FIND(" ",A1,1)+1,1000)