Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

breaking reference to a cell

Posted by Robin McNeely on September 20, 2000 9:50 AM

I have concatenated the text from 3 separate cells into
a new cell. I would like to have the newly created text
in that cell become the real values that they are, not
references to the 3 cells that they were created from.
My goal is to delete the 3 original cells and just have
the concatenated data. Is there a way in Excel to do
this?

Re: breaking reference to a cell

Posted by Tim Francis-Wright on September 20, 0100 6:18 PM

Copy the offending cell, then use the Paste Special
command, and select the Values option. You
can paste back in the same place if you don't
need to keep the formulas.

HTH

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.