concatenate cell and referncing afterwads

[valmont_2]

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.. a125 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.

 

[CLR]

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