changing formula result to constant value

P

pemily

What's the quickest, easiest way to convert the result of a formula into
a constant? For examply, I used the proper command to change fields of
data to title case. Now I need to do a mail merge, and I want to change
the fields so that the title case data is a value, rather than still
being the formula.

Thanks! Patience
 
R

Ron Coderre

For a single cell:
[F2] then [F9]

For a range:
Select the range, then
[Ctrl]+C
Edit>Paste Special>Values (then press [Enter])

Does that help?

Ro
 
P

pemily

YES!! Thank you, this is wonderful!
Patience

Ron said:
For a single cell:
[F2] then [F9]

For a range:
Select the range, then
[Ctrl]+C
Edit>Paste Special>Values (then press [Enter])

Does that help?

Ron
Click to expand...
 
P

Paul B

Pemily, one way, copy the cells then paste special, check valve, OK
--
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 & 2003
 
Q

quimrider

'The macro in this thread'
(http://www.excelforum.com/showthread.php?t=487394) will replace the
formula with it's value. If you're a noob you simply go to
Tools>Macros>Macros. then type a name for your new macro in the macro
name field and click the "create" button. Then copy and paste the
code. Then you can assign a key stroke for it. I assigned "Ctrl + P"
 
Top