Removing numbers from an excel cell, keep text

[bendarrington]

I want to remove the numbers from an excel cell but keep the text.

I have a excel sheet full of street addresses but I just want the street names, not the full address.

Is there a formula to do this?

Thanks.

 

[Jon von der Heyden]

Hi and welcome to the board.

In future it would be helpful if you could post a small sample of your data.

Assuming that the addresses are only street names with preceding numbers, perhaps;

Excel 2010
	A	B
1	Street Address	Street
2	5 The Street	The Street
3	26 Some Avenue	Some Avenue
4	18 RoadX	RoadX
Sheet1

Cell Formulas
Range	Formula
B2	=TRIM(SUBSTITUTE(A2,LOOKUP(10^308,--LEFT(A2,{1;2;3;4;5;6})),""))

 

[Rick Rothstein]

Another possibility, assuming all your addresses start with a number and are separated from the rest of the address by a space...

=MID(A2,FIND(" ",A2&" ")+1,99)