editing text in contents of joined cells
 

I import text data into rows and use formulas to join the
contents of multiple cells into a new cell on another
worksheet. Once the text has been joined and formated
(=proper, etc) in the new cell, I want to be able to edit
the combined text.

Since the new combined cell references the source cell, I
need to know how to edit/append text in the new cell. Is
this possible? Is there a "post" function that will post
the combined cell's content and permit me to edit it?

editing text in contents of joined cells
 

Patrick

two choices: either copy the cell(s) and PasteSpecial Values back into the
cell(s). Then edit the text. Or use "&" to concatenate additional text
onto the formulas in the cell(s)

Regards

Trevor


"Patrick" wrote in message
...
I import text data into rows and use formulas to join the
contents of multiple cells into a new cell on another
worksheet. Once the text has been joined and formated
(=proper, etc) in the new cell, I want to be able to edit
the combined text.

Since the new combined cell references the source cell, I
need to know how to edit/append text in the new cell. Is
this possible? Is there a "post" function that will post
the combined cell's content and permit me to edit it?