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.
 
Back
Top