software

I want to copy just the results of formulas in a series of cells and not the
formulas. that is i want to copy the values in cells.


Select the cells, edit copy. Go to the destination choose edit, paste
special and choose values

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=517473Copy gt; PasteSpecial gt; Values..........

Vaya con Dios,
Chuck, CABGx3
quot;Holden Caulfieldquot; wrote:

gt; I want to copy just the results of formulas in a series of cells and not the
gt; formulas. that is i want to copy the values in cells.

Holden, copy the cells, right click where you want the results and paste
special, valves
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 amp; 2003

quot;Holden Caulfieldquot; lt;Holden gt; wrote in
message ...
gt;I want to copy just the results of formulas in a series of cells and not
gt;the
gt; formulas. that is i want to copy the values in cells.
Use quot;Paste Specialquot; instead of quot;Pastequot;. You'll then have an option to select
just quot;Valuesquot;.

HTH,
Elkarquot;Holden Caulfieldquot; wrote:

gt; I want to copy just the results of formulas in a series of cells and not the
gt; formulas. that is i want to copy the values in cells.


quot;Holden Caulfieldquot; lt;Holden gt; wrote in
message ...
gt;I want to copy just the results of formulas in a series of cells and not
gt;the
gt; formulas. that is i want to copy the values in cells.

Instead of Paste, go to the menu amp; click Edit, Paste Special, and select
Values. Lots of other interesting options there, too, like Formats, which is
especially handy sometimes.
thank you. HC

quot;CLRquot; wrote:

gt; Copy gt; PasteSpecial gt; Values..........
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Holden Caulfieldquot; wrote:
gt;
gt; gt; I want to copy just the results of formulas in a series of cells and not the
gt; gt; formulas. that is i want to copy the values in cells.

thanks Dav. HC

quot;Davquot; wrote:

gt;
gt; Select the cells, edit copy. Go to the destination choose edit, paste
gt; special and choose values
gt;
gt; Regards
gt;
gt; Dav
gt;
gt;
gt; --
gt; Dav
gt; ------------------------------------------------------------------------
gt; Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
gt; View this thread: www.excelforum.com/showthread...hreadid=517473
gt;
gt;

thanks HC

quot;Elkarquot; wrote:

gt; Use quot;Paste Specialquot; instead of quot;Pastequot;. You'll then have an option to select
gt; just quot;Valuesquot;.
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;Holden Caulfieldquot; wrote:
gt;
gt; gt; I want to copy just the results of formulas in a series of cells and not the
gt; gt; formulas. that is i want to copy the values in cells.

thanks paul. HC

quot;Paul Bquot; wrote:

gt; Holden, copy the cells, right click where you want the results and paste
gt; special, valves
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Holden Caulfieldquot; lt;Holden gt; wrote in
gt; message ...
gt; gt;I want to copy just the results of formulas in a series of cells and not
gt; gt;the
gt; gt; formulas. that is i want to copy the values in cells.
gt;
gt;
gt;