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
|