changing a column to all caps in excel without a helper column

Question

I have a column of names in mixed case and need them uppercase. UPPER() works but puts the result in another column. Can it be done in place?

stella_gadget · Answer

Excel has no change case button, annoyingly. Quickest real trick: copy the column into Word, select it, Shift+F3 until it's all caps, copy and paste it back over the original. Or Power Query if the data is a table - Transform > Format > UPPERCASE works in place.

changing a column to all caps in excel without a helper column

Leave A Reply

1 Answer