I have a sheet where full addresses with House numbers and street names are
in the same cell

Example: 123 Elm Street

Is there a way I can seperate the Number from the rest of the text? I need
to do this so I can write a formula that will create Whitepages phone number
search links, and their site requires the number to be seperated.

Thanks for any help!

Cameron

Use a coupe of helper columns. To get the number (Imagining that the current
address is in A1

To get the number

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

And in another column to get the street

=MID(A1,FIND(" ",A1)+1,LEN(A1)-FIND(" ",A1))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Cameron" wrote in message
...
I have a sheet where full addresses with House numbers and street names are
in the same cell

Example: 123 Elm Street

Is there a way I can seperate the Number from the rest of the text? I need
to do this so I can write a formula that will create Whitepages phone
number
search links, and their site requires the number to be seperated.

Thanks for any help!

PERFECT! Thank you Nick!