edit text of combined cells

[Patrick]

Hello,

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?

The edited contents has no relationship to the original
cells. The object is to collect data, merge select fields,
edit and append the new contents and link that information
elsewhere.

thanks,

Patrick

 

[Peo Sjoblom]

Copy the the cells and paste special as values, then select the cell
and press F2 to start editing