Forum Discussion

NEDNARB's avatar
NEDNARB
Copper Contributor
Sep 26, 2019

=UPPER(A1)

OK, I'm really bad at excel, so excuse me please, but I've created a cell that uses the =UPPER(A1) formula. Worked great, but now I want to copy that text to A1. but it breaks the reference. Is ther...
excel
Formulas and Functions
Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Sep 27, 2019

NEDNARB 

To do that, follow these steps...

  1. Select the formula cell/cells.
  2. Right click on one of the selected cells and choose Copy or press Ctrl+C to copy the selection.
  3. Right click in A1 and choose paste icon with 123 over it i.e. paste as Values. Or select the cell A1 and press the keys Alt,E,S,V and hit Enter.

  • Silvy23's avatar
    Silvy23
    Copper Contributor
    Mar 27, 2020
    I did this but all I can see is the formula...what am I screwing up?
    • PReagan's avatar
      PReagan
      Bronze Contributor
      Mar 27, 2020

      Hello Silvy23,

       

      Be sure that you have turned off "Show Formulas" located in the Formula Tab.

      Alternatively, you may use the shortcut Ctrl + ` (not to be confused with Ctrl + ').

Resources