How to convert entire excel document from lower to upper case

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm merging several excel documents and some are lower case and some are all
in upper case. How can I convert the entire document from one to the other?
Thanks for any suggestions I get.
Paul
 
Apply the UPPER() function to all the text, then do a Copy/Paste Special
values to convert the results back to text
 
You must log in or register to reply here.

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

Lower-Case Characters 2
Upper case to Lower case 5
filtering to separate upper & lower case 5
UPPER function 2
Upper Case vs. Lower Case Add-Ins 5
Validate data but then change the entry to upper case 4
Change lower case to upper case 6
Upper case to Lower case 7

Back
Top