Untested:

I = instr(activecell.value," ")
if I 0 then
activecell.value = mid(activecell.value, I+1)
End if

Instr returns the starting location of a string, in this case a space.
Mid, returns the text starting at the I+1 character postion.

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"andy peo" wrote in message
...
I have spent the last few hours trying to find out haw to delete
numbers in the first line of the address in excel, by using a macro or
formula.

For example

In a particular cell I would have

35 Mill View Road and I want to strip the numbers just to leave Mill
View Road.

I'm a Novice when programming in Excel.

Hope somebody can help me, Thanks in advance

Regards

Andy P