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

Not sure how you will determine what info is real 'address info' and
what is garbage. But assuming the info in the columns actually makes
up part of the address, just combine the columns like =A1&A2&A3


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=557517

Sorry, I didn't make myself clear.

I have over 10,000 rows of data. Each row has 3 address columns that
different data entry people over the years have entered eroneous
address info into such as dba data, or actual addresses, or suite/apt
numbers.

I need to look at these three columns, extract the street address from
one of the three columns and place it in a new column.

I don't want to combine all three columns.

Thanks,
Betsy



Mallycat wrote:
Not sure how you will determine what info is real 'address info' and
what is garbage. But assuming the info in the columns actually makes
up part of the address, just combine the columns like =A1&A2&A3


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=557517