How can I cange text to lowercase in Excel

G

Guest

I have some imported data that came in all caps. Is there anyway to change
the data to upper and lower case?
 
B

Bernard Liengme

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
Title Case in Excel 3
Format Cell - Only Upper Case Alpha characters 3
lowercase to caps 1
Need to Change Case from Mixed to Caps 7

Top