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