A question from Los Gatos (I won’t hold it against him that he’s from a town called “The Cats”). How do you convert a whole column of text from lower case to upper case?
I don’t know any way to do that in the user interface. Scratch that, I do know one way: You can buy JWalk’s PUP5 Add-in. If you want to do it yourself, you’ll need to use VBA. This example converts all the text in A1:A12 to upper case.
Dim rcell As Range
For Each rcell In Sheet1.Range(“A1:A12”).Cells
rcell.Value = UCase(rcell.Value)
To convert to lower case, use the LCase function instead of UCase. To convert to proper case, see this post.
Of course you always have the option of one-at-a-timing it with the UPPER, LOWER, and PROPER worksheet functions.