Home

=UPPER(A1)

%3CLINGO-SUB%20id%3D%22lingo-sub-877841%22%20slang%3D%22en-US%22%3E%3DUPPER(A1)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-877841%22%20slang%3D%22en-US%22%3E%3CP%3EOK%2C%20I'm%20really%20bad%20at%20excel%2C%20so%20excuse%20me%20please%2C%20but%20I've%20created%20a%20cell%20that%20uses%20the%20%3DUPPER(A1)%20formula.%3C%2FP%3E%3CP%3EWorked%20great%2C%20but%20now%20I%20want%20to%20copy%20that%20text%20to%20A1.%20but%20it%20breaks%20the%20reference.%20Is%20there%20a%20way%20to%20flatten%20a%20cell%20so%20that%20it%20is%20no%20longer%20associated%20with%20its%20formula%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-877841%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-877936%22%20slang%3D%22en-US%22%3ERe%3A%20%3DUPPER(A1)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-877936%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415976%22%20target%3D%22_blank%22%3E%40NEDNARB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20copy%20the%20cell%20and%20paste%20into%20another%20one%20as%20value.%20Check%20the%20option%20in%20right%20click%20menu%20or%20in%20Paste%20menu%20on%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-878242%22%20slang%3D%22en-US%22%3ERe%3A%20%3DUPPER(A1)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878242%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415976%22%20target%3D%22_blank%22%3E%40NEDNARB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20do%20that%2C%20follow%20these%20steps...%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20the%20formula%20cell%2Fcells.%3C%2FLI%3E%3CLI%3ERight%20click%20on%20one%20of%20the%20selected%20cells%20and%20choose%20Copy%20or%20press%20Ctrl%2BC%20to%20copy%20the%20selection.%3C%2FLI%3E%3CLI%3ERight%20click%20in%20A1%20and%20choose%20paste%20icon%20with%20123%20over%20it%20i.e.%20paste%20as%20Values.%20Or%20select%20the%20cell%20A1%20and%20press%20the%20keys%20Alt%2CE%2CS%2CV%20and%20hit%20Enter.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20600px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133715i4E1750CD426CA208%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Upper.gif%22%20title%3D%22Upper.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-878642%22%20slang%3D%22en-US%22%3ERe%3A%20%3DUPPER(A1)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-878642%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415976%22%20target%3D%22_blank%22%3E%40NEDNARB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20generalise%20a%20bit.%20To%20copy%20selected%20cell%2Frange%3C%2FP%3E%0A%3CP%3Ewith%20Ribbon%3C%2FP%3E%0A%3CP%3E-by%20mouse%3A%20click%20Copy%20button%3C%2FP%3E%0A%3CP%3E-%20by%20keyboard%3A%20press%20sequentially%20Alt%2CH%2CC%2CC%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewith%20context%20menu%3C%2FP%3E%0A%3CP%3E-by%20mouse%3A%20right%20click%20and%20in%20appeared%20menu%20click%20Copy%20button%3C%2FP%3E%0A%3CP%3E-%26nbsp%3Bby%20keyboard%3A%20press%20context%20menu%20button%20(near%20the%20right%20Ctrl%20on%20keyboard)%2C%20navigate%20by%20Arrow%20Down%20to%20Copy%20icon%2C%20Enter%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewith%20keyboard%20shortcut%3C%2FP%3E%0A%3CP%3E-%20Ctrl%2BC%3B%20or%3C%2FP%3E%0A%3CP%3E-%20Ctrl%2BIns%3C%2FP%3E%0A%3CP%3E(with%20keyboard%20shortcuts%20keep%20pressed%20first%20button%20and%20release%20it%20after%20all%20next%20buttons%20were%20pressed%20sequentially)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20past%20value%20into%20target%20cell%2Frange%3C%2FP%3E%0A%3CP%3Ewith%20Ribbon%3C%2FP%3E%0A%3CP%3E-by%20mouse%3A%20expand%20menu%20under%20Paste%20button%20and%20click%20on%20123%20icon%3B%20or%3C%2FP%3E%0A%3CP%3Eexpand%20menu%20under%20Paste%20button%2C%20click%20on%20Paste%20Special%2C%20select%20Values%2C%20click%20Ok%3C%2FP%3E%0A%3CP%3E-%20by%20keyboard%3A%20press%20sequentially%20Alt%2CH%2CV%2CV%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewith%20context%20menu%3C%2FP%3E%0A%3CP%3E-by%20mouse%3A%20right%20click%20and%20in%20appeared%20menu%20click%20on%20on%20123%20icon%3C%2FP%3E%0A%3CP%3E-%26nbsp%3Bby%20keyboard%3A%20press%20context%20menu%20button%20%2C%20navigate%20on%20123%20icon%20by%20Arrow%20Down%2C%20Arrow%20Right%2C%20Enter%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewith%20keyboard%20shortcut%3C%2FP%3E%0A%3CP%3E-%20Ctrl%2BV%20or%26nbsp%3BShift%2BIns%2C%20press%20Ctrl%20to%20expand%20Quick%20access%20menu%2C%20navigate%20to%20123%20icon%20by%20Arrow%20Down%2C%20Enter%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20more%20option%20is%20to%20add%20Copy%20and%20Paste%20Values%20icons%20to%20Quick%20Access%20Toolbar%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20434px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133739i2624A1EBC3171E19%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20do%20operations%20with%20one%20click%20on%20them%3B%20or%20by%20keyboard%20Alt%2CN%20where%20N%20sequential%20position%20number%20of%20the%20icon%20in%20toolbar.%20I%20my%20case%20to%20paste%20values%20is%20Alt%2C9%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EForgot%20something%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879334%22%20slang%3D%22en-US%22%3ERe%3A%20%3DUPPER(A1)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879334%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415976%22%20target%3D%22_blank%22%3E%40NEDNARB%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3Bboth%20offered%20great%20solutions.%3C%2FP%3E%3CP%3EHere%20is%20the%20shortcut%20I%20like%20to%20use%20when%20pasting%20as%20values%3A%3C%2FP%3E%3CP%3E1.%20Ctrl%2BC%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-%26nbsp%3B%20(Copy%20cell)%3C%2FP%3E%3CP%3E2.%20Ctrl%2BV%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-%26nbsp%3B%20(Paste%20cell)%3C%2FP%3E%3CP%3E3.%20Ctrl%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-%26nbsp%3B%20(Paste%20options)%3C%2FP%3E%3CP%3E4.%20V%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-%26nbsp%3B%20(Values)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20found%20that%20this%20method%20is%20quick%20and%20easy%20to%20remember.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-879556%22%20slang%3D%22en-US%22%3ERe%3A%20%3DUPPER(A1)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EApproximately%20the%20same%2C%20but%20I%20never%20can%20find%20C%20and%20V%20without%20moving%20focus%20on%20keyboard.%3C%2FP%3E%0A%3CP%3EThus%3C%2FP%3E%0A%3CP%3ECtrl%2BIns%3C%2FP%3E%0A%3CP%3EShift%2BIns%3C%2FP%3E%0A%3CP%3ECtrl%3C%2FP%3E%0A%3CP%3EDown%3C%2FP%3E%0A%3CP%3EDown%3C%2FP%3E%0A%3CP%3EEnter%3C%2FP%3E%0A%3CP%3EAbove%20buttons%20are%20pressed%20practically%20automatically%20with%20some%20help%20of%20peripheral%20vision%20since%20they%20are%20practically%20isolated.%20If%20we%20speak%20about%20full%20scale%20keyboard.%3C%2FP%3E%3C%2FLINGO-BODY%3E
NEDNARB
Occasional Visitor

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 there a way to flatten a cell so that it is no longer associated with its formula?

5 Replies

@NEDNARB 

You may copy the cell and paste into another one as value. Check the option in right click menu or in Paste menu on ribbon.

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

Upper.gif

@NEDNARB 

To generalise a bit. To copy selected cell/range

with Ribbon

-by mouse: click Copy button

- by keyboard: press sequentially Alt,H,C,C

 

with context menu

-by mouse: right click and in appeared menu click Copy button

- by keyboard: press context menu button (near the right Ctrl on keyboard), navigate by Arrow Down to Copy icon, Enter

 

with keyboard shortcut

- Ctrl+C; or

- Ctrl+Ins

(with keyboard shortcuts keep pressed first button and release it after all next buttons were pressed sequentially)

 

To past value into target cell/range

with Ribbon

-by mouse: expand menu under Paste button and click on 123 icon; or

expand menu under Paste button, click on Paste Special, select Values, click Ok

- by keyboard: press sequentially Alt,H,V,V

 

with context menu

-by mouse: right click and in appeared menu click on on 123 icon

- by keyboard: press context menu button , navigate on 123 icon by Arrow Down, Arrow Right, Enter

 

with keyboard shortcut

- Ctrl+V or Shift+Ins, press Ctrl to expand Quick access menu, navigate to 123 icon by Arrow Down, Enter

 

One more option is to add Copy and Paste Values icons to Quick Access Toolbar

image.png

and do operations with one click on them; or by keyboard Alt,N where N sequential position number of the icon in toolbar. I my case to paste values is Alt,9

 

Forgot something?

Hello @NEDNARB,

 

@Sergei Baklan and @Subodh_Tiwari_sktneer both offered great solutions.

Here is the shortcut I like to use when pasting as values:

1. Ctrl+C      -  (Copy cell)

2. Ctrl+V      -  (Paste cell)

3. Ctrl      -  (Paste options)

4. V      -  (Values)

 

I have found that this method is quick and easy to remember.

@PReagan 

Approximately the same, but I never can find C and V without moving focus on keyboard.

Thus

Ctrl+Ins

Shift+Ins

Ctrl

Down

Down

Enter

Above buttons are pressed practically automatically with some help of peripheral vision since they are practically isolated. If we speak about full scale keyboard.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies