Is there anyway in Excel to change the case of text in a cell. (kinda like highlight then shift+F3 in Word)?

Question

When highlighting text and pressing Shift+F3 in Word - it cycles between all caps, all lower case, and Sentance case.

Is there any easy way to do somthing similar in Excel?

Answer 1

Look up the following functions in help:

UPPER()
LOWER()
PROPER()

They will allow you to format text in a cell.

Answer 2

As someone has said, you can wrap text, or even merge a couple of cells together. To wrap the text, either right button of mouse, format cells, alignment, wrap text or, if you have already typed it, click in the cell, then click in the formula bar where you can see it and where you want the break in lines use Alt Enter to force the words onto next line within same cell. Excel is not really designed for long descriptions and as you yourself say it is 'comments' perhaps you should consider using a comment instead of normal cell (right button of mouse insert comment). The comment is then in a separate box which you can move away from the cell in case it covers other data in other columns, and right button of mouse to show or edit comment. However, as you appear to be using your spreadsheet purely for text, I would advise using a table in Word instead which is more used to text. In that case assuming 2.5 cm margins all the way round and you are working in A4 landscape your first column could be 2 cm wide to accommodate name and the second column 22cm wide to accommodate the comments. You can always cut and paste rather than retying if you want to try this. It would then automatically go into Word as a table and you just need to change the widths. Another advantage of using Word is, as you type in one cell, when it gets to the end margin of that particular cell the text would automatically wrap to the next line.

Answer 3

Highlight the cell and then make the change. But if you're only looking to change the case, no. In excel, changing the case is manual.

Answer 4

I don't know about doing it automatically, but you can use a formula to do it, just click a cell that's clear of any values, then change "sum" to "upper" for upper case, "lower" for lower case, and (I think) "title" for title case. So you would put something like "=upper(A1)" and then just use the autofill feature to do the same to the rest of them. Then simply replace the old column with the new one.

Answer 5

Interesting...I use buttons for a lot of shortcuts, but I don't see one for changing case. You can change the font of the text, direction, font size, bold, italicize and underline, but you can't change case. I would imagine it's because one would most often change the case of only one letter, but in a Excel you usually work with a whole cell.

Good question.