How do I quickly change text case in Excel?

L

Llawler

I tried using the formula, but all I get back in the cell is the formula, not
the revised text.
 
P

Peter Jausovec

Hi,

You can use this piece of code (if the UPPER function doesn't work for you)
to change the selected text in the cells to uppercase:

Dim c As Range

For Each c In Selection
c.Value = UCase(c.Value)
Next

Hope this helps.
--
Best regards,
Peter Jaušovec
http://blog.jausovec.net



"Llawler" je napisal:
 
L

Llawler

I wish I was more savvy in Excel to be able to use code, but I am not. Thanks
for your input, though.
 
R

RagDyeR

First, make sure that you're not in 'Formula View'.

<Tools> <Options> <View> tab,
And under "Window Options", make sure 'Formulas' is
*Unchecked*.

If that's not the case, then you probably have the cell containing the
formula formatted to 'Text'.
You must change the cell format to "General"
*AND*, re-enter the formula by just clicking in the formula bar and hitting
<Enter>.

you can try clicking in the "bad" cell and then:
<Ctrl> <Shift> < ~ >
Then
<F2> <Enter>

Which is a keyboard shortcut for what was described above.

If you have a large number of these "bad" cells, you can change then en
masse.
Select the "bad" cells and,
<Edit> <Replace>
In "Find What", enter
=
And in "Replace With", enter
=
Then click "Replace All".

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I tried using the formula, but all I get back in the cell is the formula,
not
the revised text.
 
Top