i have a database table i wish to concatenate into one column, then i would
like to reference that inforation -column,row and ref individual bits of
information inside of the concatenated data for formaula. is this possible?

ex.. a1:p25 is varied data types - some dates some alphanumeric.
would like to ref for conditional statements.

reason for concatenation is to ref archive data within same worksheet.

One thing yu might consider, is to put a unique symbol, like @ or something
that is not contained within your data as a separator between each and every
concatenated cell.........then the columns can be stored out of sight, and
when you want to search one, you could call it to a workplace and do Data
Text to columns using that symbol as a delimiter and you would have your
data all blown out like it was originally........do a search, copy the
desired info out to another work area, and delete the first work area
contents........your data is still safe in it's original column..........

hth
Vaya con Dios,
Chuck, CABGx3


"valmont_2" wrote in message
...
i have a database table i wish to concatenate into one column, then i
would
like to reference that inforation -column,row and ref individual bits of
information inside of the concatenated data for formaula. is this
possible?

ex.. a1:p25 is varied data types - some dates some alphanumeric.
would like to ref for conditional statements.

reason for concatenation is to ref archive data within same worksheet.