thanks for any help, I need to separate the house number from the street name
in a sheet that has 10,000 lines.

Assuming your data is in Col A and house number and street names are
separated by a space then use this in B1
=LEFT(A1,FIND(" ",A1)-1) to get house no
and this in C1
=RIGHT(A1,LEN(A1)-FIND(" ",A1)) to get street name
and copy donw

"suncat" wrote:

thanks for any help, I need to separate the house number from the street name
in a sheet that has 10,000 lines.

Sheeloo;214722 Wrote:
Assuming your data is in Col A and house number and street names are
separated by a space then use this in B1
=LEFT(A1,FIND(" ",A1)-1) to get house no
and this in C1
=RIGHT(A1,LEN(A1)-FIND(" ",A1)) to get street name
and copy donw

"suncat" wrote:

thanks for any help, I need to separate the house number from the
street name
in a sheet that has 10,000 lines.
Select the column
Go to Data text to columns
use space as delimiter
OK


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58948

Just use text to columns (Data , text to columns) click delimited tick the
space box

Job done

"Pecoflyer" wrote in message
...

Sheeloo;214722 Wrote:
Assuming your data is in Col A and house number and street names are
separated by a space then use this in B1
=LEFT(A1,FIND(" ",A1)-1) to get house no
and this in C1
=RIGHT(A1,LEN(A1)-FIND(" ",A1)) to get street name
and copy donw

"suncat" wrote:

thanks for any help, I need to separate the house number from the
street name
in a sheet that has 10,000 lines.
Select the column
Go to Data text to columns
use space as delimiter
OK


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58948

How many columns does the OP want the street name split into if it has
spaces in it?
I think I'd stick with Sheeloo's suggestion.
--
David Biddulph

"Pecoflyer" wrote in message
...

Select the column
Go to Data text to columns
use space as delimiter
OK
--
Pecoflyer

Sheeloo;214722 Wrote:
Assuming your data is in Col A and house number and street names are
separated by a space then use this in B1
=LEFT(A1,FIND(" ",A1)-1) to get house no
and this in C1
=RIGHT(A1,LEN(A1)-FIND(" ",A1)) to get street name
and copy donw

"suncat" wrote:

thanks for any help, I need to separate the house number from the
street name
in a sheet that has 10,000 lines.