Just use the UPPER() function in cell to the right and fill down as
needed.

For example if you are doing this in column B, type =UPPER(A1) in cell
B1, then click the fill handle to complete the sequence.


Check out http://www.bettersolutions.com/excel...T423111411.htm
for visual aid.


HTH,
JP

On Jan 4, 2:51*pm, Patti wrote:
Is there a way to change multiple cells from lower case to upper case? *I
figured out how to format one cell at a time, but not multiple.
--
Patti