Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
breaking reference to a cellPosted 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
Re: breaking reference to a cellPosted 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.
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.