formula for, if excel cell range ( 3 cells in row) contains any number copy entire cell to another cell

[PeterNYC212]

I have a spread sheet with up to 4 columns of names, then the last cell is the actual address. But I am looking to move the adress cell its own column. It could like like any of the examples below. Looking to move the address field into a new single column. Is there an recommended formula for this. My thought was if the cell started with or contained any number value I would copy that entire cell into a new cell, and create a single column with the addess. I appreciate any help on this. Thank you

JEANETTE P ESPOSITO TR

JOHN L ESPOSITO LIV TRUST

JEANETTE P ESPOSITO LIV TRUST

875 WHISKEY CREEK DR

SARA N LEIDAL

MARGRET N FLORIO

2575 MAIDENS ROAD

DONA LEIDER

1756 LUDLOW RD

 

[PeterNYC212]

Not sure if I uploadrd xl2bb clip right but will try again

Ill try it again.

 

[PeterNYC212]

Not sure if I uploadrd xl2bb clip right but will try again

thank you. Its working as expected. I think it was how I was copying it down the column.

 

[Fluff]

Glad we could help & thanks for the feedback.