Removing characters from a string

[MoeFoxx]

I have a column of cells with addresses some of which have ℅ in front of the address. I want to remove all letter characters from left to right up until the first number(which is the street number)

Here are some examples. There are different amounts of characters and spaces before the first number.

I'd like a formula to do this. Thanks alot!

C/O RONALD RATTRAY
4038 S SHADE AVE, SARASOTA, FL, 34231-4630

C/O RONALD K MC KINNEY
648 ROCKAWAY PKWY, BROOKLYN, NY, 11236-1318

C/O RON & BETTY REED
5400 COLLINS LAKE RD APT1207, JACKSONVILLE, FL, 32244

C/O ROMAN M WHITT
6327 S INGALLS ST, LITTLETON, CO, 80123-3846

[Phuocam]

Try this:

=REPLACE(A1,1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1,"")

[Glenn Kennedy]

Or if (as in your description) the extra stuff is on a separate line:

=IFERROR(MID(A1,SEARCH(CHAR(10),A1)+1,255),A1)

BtW, it is ALWAYS better to attach a sample sheet, instead of dropping text into the thread... as the Forum often messes up the formatting.

[MoeFoxx]

Try this:

=REPLACE(A1,1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1,"")

That works great thanks so much

[MoeFoxx]

How to I show this thread is solved? Sorry for the dumb question.

[Glenn Kennedy]

Immediately above your first post in this thread... "Thread Tools" last option.