how do I format a cell to display its contents in Upper case?

M

MarcM

I'm entering information in a spreadsheet that gets uploaded to a database.
The contents of some of the cells need to be in uppercase.
Is there a way to format the cell in such a way that it changes the case of
the content to upper case. So, if I type in ser, the cell content changes to
SER.
 
B

Bob Umlas, Excel MVP

you need VBA to do this , not formatting. in the Worksheet_Change event,
Target.value=Ucase(target.Value)
 

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

Excel does not accept text format! 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Place picture in Excel cell 0
Conditional formatting disappears when cell contents deleted 2
AppleScript - How do I select a text ? 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Word doc keeps changing to ALL CAPS 0
Formatting cells to only upper case 5

Top