changing a column to all caps in excel without a helper column
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?