I want to convert a formula to the actual number/verbage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sheryll from Connecticut - 05 Feb 2008 20:56 GMT

For example:
I had a worksheet with lowercase verbage in several cells. I wanted to have
the verbage written in all uppercase, so I used the "Upper" formula to
convert it. But now I would like to change it to the absolute verbage rather
than a formula (Or converting a formula to the actual number in the cell) I
used to be able to do this in LOTUS, but can't remember how. I just remember
that it was as simple as hitting CTR and then another key. Not sure if it
would be the same in Excel anyway.

Reply to this Message

Laura Cook - 05 Feb 2008 21:06 GMT

Select the cells. Then Copy, Paste Special > Values.

Laura

> For example:
> I had a worksheet with lowercase verbage in several cells. I wanted to
[quoted text clipped - 8 lines]
> that it was as simple as hitting CTR and then another key. Not sure if it
> would be the same in Excel anyway.

Reply to this Message

Rick Rothstein (MVP - VB) - 05 Feb 2008 21:10 GMT

Select the cell or cells you want to convert to their displayed values, copy
it/them (either click Edit/Copy from the menu or key-in Ctrl+C), and then
click Edit/PasteSpecial from the menu and select Values before clicking OK.

Rick

Reply to this Message

MrAcquire - 05 Feb 2008 22:14 GMT

I think you mean the following:
1. Edit - Copy.
2. Edit - PasteSpecial - Values - OK.

> For example:
> I had a worksheet with lowercase verbage in several cells. I wanted to have
[quoted text clipped - 4 lines]
> that it was as simple as hitting CTR and then another key. Not sure if it
> would be the same in Excel anyway.

Reply to this Message