Can someone please help me???

[Betsy]

I have 3 columns of data that I need to extricate specific data from.

IE.

One row might read:
Column A - Ogden Equity
Column B - 5806 Coconut Blvd
Column C - Apt 345

while another row might read:
Column A - 5806 Coconut Blvd
Column B - Ogden Equity
Column C - Apt 345

and so on and so forth. I need to create a new column that lists only
the street addresses.

Beth

 

[flummi]

Hi Beth,

If this is still a problem, are there any criteria at all that define
what makes an entry in a cell a street address i.e. any cell entry
starting with a number could be interpreted as the city (if
applicable).

Regards

Hans