capital letters in excel

G

Guest

Is there a way to create capital letters in excel without using the caps
lock? Thanks.
 
P

Paul Corrado

You can use the function

=UPPER("text") which will return TEXT

Or use it in another cell and replace the hard coded text entry with a cell
reference.




"Capital Letters in Excel" <Capital Letters in
(e-mail address removed)> wrote in message
news:[email protected]...
 

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

conditional formatting - highlight Capital letters but not lower c 2
how to change small letters to capital letters 4
Changing grey column headings from numbers back to capital letters 2
how do i turn all letters into capital letters? 3
changing capslock letters into normal letters 4
display months (in date format) in capital letters 3
Selectively printing 1
HOW TO COUNT CAPITAL LETTERS IN DATA? 1

Top