From Lower Case to Upper Case

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JERRY - 18 Jun 2007 20:14 GMT

I know Excel is not supposed to be a Word Processing program. Nevertheless,
I have a lot of text on a work sheet that is all upper case. Is there a
quick fix for converting upper case to lower case without exporting it to
another application, changing the case and importing it back again. Thank
you for any help here.

Jerry

Reply to this Message

Pete_UK - 18 Jun 2007 20:44 GMT

You can enter this formula in a blank cell:

=UPPER(A1)

to convert whatever is in A1 to upper case, and then copy the formula
down the column for as many entries as there are in column A. You can
do this for other columns as necessary and then fix the values using
<copy> | Edit | Paste Special | Values (check) then OK and <Esc> and
then you can delete the original columns.

Hope this helps.

Pete

> I know Excel is not supposed to be a Word Processing program. Nevertheless,
> I have a lot of text on a work sheet that is all upper case. Is there a
[quoted text clipped - 3 lines]
>
> Jerry

Reply to this Message

Gord Dibben - 18 Jun 2007 21:03 GMT

Or more aptly =LOWER(A1)

Or =PROPER(A1)

If you don't want to deal with that many formulas you can do the whole sheet at
once with a macro.

Post back if that would be your choice.

Gord Dibben MS Excel MVP

>You can enter this formula in a blank cell:
>
[quoted text clipped - 17 lines]
>>
>> Jerry

Reply to this Message

JERRY - 19 Jun 2007 01:55 GMT

Thanks guys. That is a big help
Jerry

> Or more aptly =LOWER(A1)
>
[quoted text clipped - 32 lines]
>>>
>>> Jerry

Reply to this Message