How do I select(fast) parts of long doc?

S

suncat

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

Sheeloo

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
 
P

Pecoflyer

Sheeloo;214722 said:
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
Click to expand...
Select the column
Go to Data text to columns
use space as delimiter
O

--
Pecoflye

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

*Adding your XL version* to your post helps finding solution faste
 
S

Stig - tame racing driver

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

Job done
 
D

David Biddulph

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