Can you change current small text in a cell to CAPITALS?

  • Thread starter Thread starter Chris K
  • Start date Start date
per teh functions list for TEXT data, UPPER will convert all the text into
all capital letters
 
To add on to Pete's answer, You can highlight the results from Column B
(assuming that's where you did Pete's formula) and Copy. Go to Column A and
do Paste Special, Values. Then you can clear out/delete Column B and you'll
be back to square one, but with everything in CAPS.
 

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

Capital Text 8
how to change small letters to capital letters 4
Capitals 3
HOW TO COUNT CAPITAL LETTERS IN DATA? 1
how do i change the words from lower case to uppercase/capitals 3
changed to capital letter 3
Capitalized Excel Data 1
Count # of Capitalized Characters 3

Back
Top