How do I quickly change text case in Excel?
 

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

How do I quickly change text case in Excel?
 

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:

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

How do I quickly change text case in Excel?
 

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

"Peter Jausovec" wrote:

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:

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

How do I quickly change text case in Excel?
 

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!
================================================== ===


"Llawler" wrote in message
...
I tried using the formula, but all I get back in the cell is the formula,
not
the revised text.