Hi,

I want to allow text editing after concatenation (is that a word?). So I
want to collate text entries from various cells on the worksheet and display
them in a single cell, so I have used the Concatenate formula. I can manually
convert the text to an editable format by copying the cell and pasting it
back into the same cell as "value" only. Does anyone know of an automatic way
of achieving the same result?

Thanks,


Fozeye.