Change Text Case

[Lilbit]

In March of 2004, someone asked how to make all text characters in cells
uppercase. While personally this is something I would not want to do,
someone in my office has posed the question. I searched for a similar
query and found that in March of 2004, someone asked the same question.
McRitchie of MVP responded by saying, "You can use the UPPER Worksheet
Function
=UPPER(A1)
followed by use of the fill handle, but then you have the original value
and the new value in two
separate cells, and have to go through some extra bother to copy the new
column, Edit, paste special, values, before you can remove the original
column." What? If I have text in A1 to A6, I put =Upper(A1) where and
fill what? Thanks!!

 

[JE McGimpsey]

Put the formula in an empty column, say column B:

B1: =Upper(A1)

Copy the formula down to B6. Select B1:B6. Copy the range. Select A1:A6.
Choose Edit/Paste Special, and select the Values radio button. Click OK.

 

[Lilbit]

Thank you very much!! It worked like a charm!!!

 

[David McRitchie]

Hi Lilbit,
and as you kind quoted part of one of my responses, you now have the
value in two columns. If you simply want to change the
original column or other selection of cells in place you would use
a macro as in http://www.mvps.org/dmcritchie/excel/proper.htm#upper

You select, run macro, and you would be done ...

as opposed to a little dance after using a formula =UPPER(A1), comprised of

Copy column B by selecting it then using Ctrl+C to copy
(optional to select column A if you want the original column changed instead of B)
Edit, Paste special, values
Now you can eliminate whichever column is extraneous

The optional switch in selection to Column A would be if other cells
refer to column A the would no longer reference a cell if you eliminated
that column.