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

V

vabki

per teh functions list for TEXT data, UPPER will convert all the text into
all capital letters
 
K

Kaman

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