editing text in contents of joined cells

[Patrick]

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?

 

[Trevor Shuttleworth]

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