Alpha numeric separation??

[dwayneh]

I have an individual column (with 4000 records) which contains alpha numeric data.
E.G - 101 Tablelands Road
I need to query each of these cells to somehow separate the number from the street address. I need two columns, one with the number and other with street name??? I have over 4000 records and would take me days to do it manually....

Please help!

Dwayne

[richardreye]

If the first space occurs between the house number and the street name then this should work.

Assumption: List start in Cell A2

In B2 type =LEFT(A2,FIND(" ",A2,1)-1)

In C2 type =RIGHT(A2,LEN(A2)-FIND(" ",A2,1))

Cheers!

[dwayneh]

Thanks Richard, this saved me heeaaappps of time. I knew there was a way to do it in Excel.

Dwayne