Hi

Make a copy of your file before you start in case things go wrong.

In cell A1 enter
=LEFT(B1,FIND(" ",B1)-1)

In cell C1 enter
=MID(B1,FIND(" ",B1)+1,255)

Copy the formulae down columns B and C as far as required.
Then, Copy the whole of column A, select cell A1, Paste SpecialValues.
Copy column C, select cell C1, Paste SpecialValues.

You can then delete column B, and you will have house numbers in A, and
Street names in B.



Regards

Roger Govier


JG wrote:
On Mon, 17 Oct 2005 21:14:37 -0400, "Anne Troy"
wrote:


Nothing goes between the quotes. What the formula is doing is finding all
the characters before a space. The " " represents the space.
************
Anne Troy
www.OfficeArticles.com


Anne this is what i have.

A1 and C1 are emty. i would like to move the numbers to column A
thanks



A B C
1 640 River Rd

2 628 River Rd

3 622 River Rd