HOW TO CONVERT TO UPPERCASE

[TER]

I am new to using EXCEL and I am having trouble converting
previously typed text to uppercase. I have discovered how to use =UPPER()
but this just places the converted entry to another cell. How do I convert
within a given cell?

 

[JE McGimpsey]

I am new to using EXCEL and I am having trouble converting
previously typed text to uppercase. I have discovered how to use =UPPER()
but this just places the converted entry to another cell. How do I convert
within a given cell?

To do it within the cell, you'll need a macro. See David McRitchie's
UPPER() macro:

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

If you're unfamiliar with macros, see David's "Getting Started with
Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[TER]

Thanks a lot for the help.

-----Original Message-----


To do it within the cell, you'll need a macro. See David McRitchie's
UPPER() macro:

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

If you're unfamiliar with macros, see David's "Getting Started with
Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm
.