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

  • Thread starter Thread starter Sheryll from Connecticut
  • Start date Start date
S

Sheryll from Connecticut

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.
 
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


"Sheryll from Connecticut" <Sheryll from
(e-mail address removed)> wrote in message
news:[email protected]...
 
I think you mean the following:
1. Edit - Copy.
2. Edit - PasteSpecial - Values - OK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

REPT FUNCTION FROM WORKBOOK TO WORKBOOK 1
how do I delete from & to names from e-mail? 1
f(x) for totaling single cell 4
How to convert a .msg File? 2
Conditional formula with text and number in cell 7
Best Ways to Convert OST to PDF? 4
Convert number to text 3
convert sum number to a set number 2

Back
Top