From Lower Case to Upper Case

[Pete_UK]

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

 

[Gord Dibben]

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

 

[JERRY]

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

 

[JERRY]

Thanks guys. That is a big help
Jerry

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