Try this:

=IF(ISERR(--LEFT(A1,FIND(" ",A1))),A1,MID(A1,FIND(" ",A1)+1,100))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"dalymjl" wrote in message
...

I have a spreadsheet containing 18,000 addresses. In some cases the
first line of the address (in Column A) contains a house number e.g.

25 High Street
124 Cherry Ave
7 King St

In other cases, the address contains no house number e.g.

Highgrove
Summerseat


Is there any way of writing the address line 1 to a new column and
deleting the house numbers from any addresses that have one? So in the
examples above I would like to end up with the following in the new
column:

High Street
Cherry Ave
King St
Highgrove
Summerset


--
dalymjl