CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING

M

MAXXMAS

I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT
HAVING TO TYPE IT OVER AGAIN. TKS
 
J

Jacob Skaria

In anotehr column apply the below formula and copy down as reuauired. Once
done copy>PasteSpecial>Values to convert formulas to values...

=LOWER(A1)
 
P

Paul C

Use the formula LOWER(A1) in an empty column and copy down.

Then copy and paste special as values over your original data. You can then
delete the formulas.
 
B

Bill Sharpe

MAXXMAS said:
I HAVE A COL OF NAME IN ALL CAPS. CAN THEY BE CHANGED TO LOWER CASE WITHOUT
HAVING TO TYPE IT OVER AGAIN. TKS
Click to expand...

and in the future, toggle your caps lock key off...

Bill
 

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

Word doc keeps changing to ALL CAPS 0
Change all text on Spread sheet 3
Publisher 2019 Format Picture window size too large to display OK button 0
How do I convert addresses to all caps in Office 2007? 3
change font from all capitals? 3
hOW DO i TURN TEXT INTO ALL CAPS? 2
Any way to change font in all styles being used in a document? 0
How do you change the Capitalization in an Excel Workbook? 7

Top