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.

Here''s the answer I gave to this same question in the Misc
group............

One thing you 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" 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.

thay may work but i dont want to handle the data more then neccessary. I
found i can use the left or right statements to extract data to a greater
deree but my problem comes about when the cell size is not constant- example
cell a1 may have 8 characters in it then cell a2 may have 12 characters in
it. therefore when coping formulas down across rows to extract information-
my method fails because cell size is not constant.

"CLR" wrote:

Here''s the answer I gave to this same question in the Misc
group............

One thing you 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" 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.