How do I quickly change text case in Excel?

[Llawler]

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

[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:

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

[Llawler]

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.

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


"Llawler" <[email protected]> wrote in message
news:[email protected]...
I tried using the formula, but all I get back in the cell is the formula,
not
the revised text.