Copying data from formula output

R

robin m

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?
 
E

Elisabeth

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

robin m

Thank you. It worked like a charm.

Elisabeth said:
Insteading of pasting, use Paste Special and select Values. That will "hard
code" your formula results.
Click to expand...
 
Top