You need to pick only the text values option from the Paste Special dialogue box to avoid formula errors later. And select the values from the options.Click on the Paste special in the context menu.Right-click on the first cell in the original column.Highlight the cells that contain the formula and press Ctrl + C to copy them.Let's copy the values from the helper column and then delete it. I suppose you'd like to leave only the correct one.

So you have two columns with the same text data but in a different case. Step 5: Now, you can remove the helper column. Hold the mouse button and drag the formula down over the cells where you want it to apply.Move your mouse cursor to the small square or fill the handle in the lower-right corner of the selected cell until you see a small cross.

Select the cell that includes the formula.

Step 4: Now, you need to copy the formula to other cells in the helper column.

B2 is the cell in the original column that has the text for conversion.Īs you can see in the above image, cell A2 contains the uppercase version of the text from cell B2.

To uppercase notepad++ shortcut