HOW DO YOU CHANGE AN ENTIRE SPREAD SHEET FROM LOWER CASE TO UPPER

G

Guest

The easiest, non-programmatic way to do this would be to add another sheet to
the existing workbook, place =UPPER(Sheet_With_LowerCase!A1) and copy this
formula throughout the entire range of the sheet, matching the range of the
Sheet that contains the lowercase text. You could then copy and paste
special as values. Programmatically, this would be much easier to do.
 

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

CHANGE LOWER CASE TO UPPER CASE? 1
Change all text on Spread sheet 1
Upper / Lower Case 1
Print Area to include text box 10
convert lower to upper case automatically without using UPPER 6
change to upper/lower case 1
how to make whole work sheet in to upper case 4
Making Sheet all Upper Case 3

Top