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


--
pemily
------------------------------------------------------------------------
pemily's Profile: http://www.excelforum.com/member.php...fo&userid=7588
View this thread: http://www.excelforum.com/showthread...hreadid=491857

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

--
Ron Coderr
-----------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...fo&userid=2141
View this thread: http://www.excelforum.com/showthread.php?threadid=49185

YES!! Thank you, this is wonderful!
Patience

Ron Coderre Wrote:
> 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


--
pemily
------------------------------------------------------------------------
pemily's Profile: http://www.excelforum.com/member.php...fo&userid=7588
View this thread: http://www.excelforum.com/showthread...hreadid=491857

Hi pemily,
You should have no problem using your converted field with
the formula in Mail Merge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

You can convert what you have by copying the range (i.e. column)
then Edit, Paste Special, Values. Then eliminate the original column.

If you would rather avoid the little dance routine you could use a
macro to convert them in place from original constants.
tp://www.mvps.org/dmcritchie/excel/proper.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"pemily" <(E-Mail Removed)> wrote in message
news(E-Mail Removed)...
>
> 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
>
>
> --
> pemily
> ------------------------------------------------------------------------
> pemily's Profile: http://www.excelforum.com/member.php...fo&userid=7588
> View this thread: http://www.excelforum.com/showthread...hreadid=491857
>

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

"pemily" <(E-Mail Removed)> wrote in
message news(E-Mail Removed)...
>
> 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
>
>
> --
> pemily
> ------------------------------------------------------------------------
> pemily's Profile:
> http://www.excelforum.com/member.php...fo&userid=7588
> View this thread: http://www.excelforum.com/showthread...hreadid=491857
>

'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"


--
quimrider
------------------------------------------------------------------------
quimrider's Profile: http://www.excelforum.com/member.php...o&userid=29009
View this thread: http://www.excelforum.com/showthread...hreadid=491857