Forcing capital letter

V

videozvideoz

Board Regular
Joined
Apr 1, 2011
Messages
51
How do I make a cell default all letters to capitals so that if someone were to type "Bacon" it would appear as "BACON" automatically? Or something like "ca 90210" would become "CA 90210"

Thanks
 
Sort by date Sort by votes

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
You must log in or register to reply here.

Similar threads

JenniferMurphy
  • Question Question
Is there a keyboard shortcut to change ALL CAPS to All Caps?
2
Replies
14
Views
4K
MARK858
MARK858
C
  • Solved
Macro to delete rows that contain specific complexity requirements
Replies
5
Views
238
caracal
C
L
  • Solved
Finding numbers in cell with text
2
Replies
10
Views
266
Lancer7
L
G
  • Locked
  • Question Question
Global Change for Conditional Formatting
Replies
1
Views
327
Fluff
Fluff
G
  • Question Question
Global Change for Conditional Formatting
Replies
2
Views
327
Micron
M

Forum statistics

Threads
1,224,602
Messages
6,179,844
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top