edit/copy
select new location
edit/paste special, select Values.
OR...
Right-click the BORDER of the selection and drag to the new location. When
you let go, you'll see a dialog in which you can select "Copy here as values
only."
Enjoy.
FYI:
I'm leading a FREE 1-hour online Webinar on Excel Tips & Tricks on
June 15, 4-5PM. If interested, go to
http://www.iil.com, click on the
yellow/orange
"Try a free webinar" link on the left side, click the Microsoft Excel
Tips & Tricks link, follow instructions to register.
"jpx" wrote in message
...
Is it possible to copy and paste just the text of a formula from one
cell to another without going into the formula text window and using
Ctrl+c. Can this be done from multiple cells to multple cells.
thanks.
--
jpx
------------------------------------------------------------------------
jpx's Profile:
http://www.excelforum.com/member.php...fo&userid=1013
View this thread: http://www.excelforum.com/showthread...hreadid=377160