How do I change from all caps to regular for existing data?

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

Guest

I received a spreadsheet from a client, I need to change the data from all
caps to regular, I have tried applying a different style, clearing formats
.....any suggestions?
 
It depends what you mean by "regular", but your could try the =Proper and =Lower
functions. Either that, or create a macro to change the cells to your
preference.
 
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

change to all caps 4
change font from all capitals? 3
Change all text on Spread sheet 1
hOW DO i TURN TEXT INTO ALL CAPS? 2
All Caps 2
Changing all caps to proper 7
convert text to sentence case 4
Help?! Format Cells for ALL CAPS 1

Back
Top