View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
andy peo andy peo is offline
external usenet poster
 
Posts: 2
Default Deleting the number in the first line of the address in a cell

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