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.
 

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

Capitals 3
how to turn automatically in CAPITALS parts of text in excel ? 3
Changing a whole spreadsheet to proper case 1
Proper Case 14
Change Capitals to Sentence Case 2
separate columns (three letter code) 7
convert underlined text to capitals 1
How do I change All Capitals Text to normal Text 1

Top