Split column on first space
 

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

Split column on first space
 

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)

--
Gary''s Student - gsnu200777


"rexmann" wrote:

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

Split column on first space
 

Job done, thank you

Rexmann

"Gary''s Student" wrote:

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)

--
Gary''s Student - gsnu200777


"rexmann" wrote:

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