extract leading numeric characters from a text string

[jacinthn]

I'm stumped, I have a cell value that is an address with leading numeric characters varying in length. I need to figure out how to either extract the leading numeric characters or insert a comma where the numeric characters end and the text string begins so I can do text to column and seperate the string.

Data eg.
342679098765 Charity House 154 w Duke St London England K45 SB7

Any ideas ?
Thanks

 

[Rick Rothstein]

Try this formula...

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

 

[jacinthn]

Thank you! that worked perfectly for extracting the numeric string. I do have another question... is there a way to keep the remaining text string without the leading numeric string. would i need to change the Left( formula to a Right( one to keep the address and not the leading numbers?

Thanks

 

[azumi]

Maybe like this...

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

Azumi

 

[jacinthn]

thats exactly what i needed thank you. thank you both so much for your help!!!!!!!!!!!!!!!!!!