Copy Value Function

[Jim Herring]

Has anyone ever hear of an Excel function called Copy Value apparently it
was in some earlier release but has been remove in the new releases of the
product. A elderly friend asked me to find out anything about it I could.
From what he told me the fuction allowed some values be copied from one set
of cells to another and then they could be sorted within the cells it was
copied to. Sounds a little funny to me. Any help would be appreciated.
Thanks /jim

 

[Alan]

Could it be Copy > Paste Special > Values? If so that built in function is
alive and well in all later Excel versions. It simply replaces the formula
in a cell to the value of the formula, that is to say the formula goes but
the value stays. Of course the values can be Paste Specialed to another
location leaving the original formulas intact.
Regards,
Alan.

 

[Max]

Perhaps you're referring to:

Edit > Copy
Edit > Paste > Paste Special > Check "Values" > OK

Then again, you might be referring to the "Paste Value" feature (one amongst
many other features) found in Jim Cone's add-in (XLExtras Release 117)
For details, try one of Jim's posts at: http://tinyurl.com/67sx2

 

[Max]

Typo in line:

Edit > Paste > Paste Special > Check "Values" > OK

should read as: