UPPER CASE formatting a cell

G

Guest

I receive excel data from a number of sources to be combined together in a
single sheet. I would like to format a column of cells to be all upper case
but not use the =UPPER() function. I'd like to format a cell to force any
lower case char to upper case automatically when data is entered. Custom
formatting as >CCCC doesn't work. Can this be done?

Conversely, how can I force cell A1 to be UPPER CASE by using =UPPER(A2),
then remove the reference to A2 when printing the result? I don't want the
cell A2 to print.
This I forget how to do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting cells to only upper case 5
Format Cell - Only Upper Case Alpha characters 3
convert lower to upper case automatically without using UPPER 6
Counting Upper and Lower case chars in a Cell 7
Excel: how to convert text to upper case upon entry? 13
how do i change an existing cell or cells to upper case? 1
Changing multiple cell text from lower case to upper case 2
1st letter upper case 5

Top