I have three address columns that different people have entered
different info in to. I need to extract the street address from one of
the three columns and put the result into a new column.

IE

Column E = might have a DBA
Column F = might have the actual street address
Column G = might have a suite or apt number

and for each row this info could be scrambled in any order.

I want to end up with Column H just having street addresses.

Thanks,
Beth