Thank you. It worked like a charm.

"Elisabeth" wrote:

Insteading of pasting, use Paste Special and select Values. That will "hard
code" your formula results.
--
Elisabeth


"robin m" wrote:

I've used my concatenate formula to merge cells. Now I need to copy the cells
to another workbook. When I paste, I get a ref#. What's up with that?