concatenate cell

[Guest]

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]

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

 

[Guest]

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.