How can I cange text to lowercase in Excel

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

Guest

I have some imported data that came in all caps. Is there anyway to change
the data to upper and lower case?
 
Search Help under PROPER and LOWER
A1 is "CAT DIED ON MONDAY, =PROPER(A1) gives "Cat Died On Monday"
while =LOWER(A1) give "cat died on monday"
best wishes
 

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

How do I convert addresses to all caps in Office 2007? 3
How do you change the Capitalization in an Excel Workbook? 7
Change all text on Spread sheet 1
Counting Characters in cells 9
Formatting cells to only upper case 5
Print Area to include text box 10
Title Case in Excel 3
Make cells in Excell case sensitive 3

Back
Top