Split column on first space

  • Thread starter Thread starter rexmann
  • Start date Start date
R

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
 
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)
 
Job done, thank you

Rexmann

Gary''s Student said:
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)
Click to expand...
 
Back
Top