Caps Lock vs Lower Case

J

JB

Hi, I need to convert cells that was typed in caps lock only, to lower case.
How do I do this without having to retype the whole cell??
 
D

David Biddulph

=LOWER(A1)
If you want to put it back in the original cell, Copy, and then Edit/ Paste
Special/ Values
 
J

Jacob Skaria

Use the below formula to convert to lower.

=LOWER(A1)

If you have a range of cells in say Sheet1; then try the below formula in
Sheet2 A1 and copy down/across as required....Once done copy/paste special
values to convert the formulas to actual values

=LOWER(Sheet1!A1)
 
M

Ms-Exl-Learner

Assume that you are having data in A column like the below:-

A1 cell
ABC

A2 cell
Abc

Paste this formula in B1 cell
=IF(EXACT(A1,UPPER(A1)),LOWER(A1),A1)

Now copy the B1 formula and paste it to B2 cell.

The result will be

B1 cell
abc

B2 cell
Abc

The above formula will convert the text to lower case only if the cell
consist the characters in Upper case. It will get the same result when the
text entry is in Proper OR Lower case.

Remember to Click Yes, if this post helps!
 
M

Ms-Exl-Learner

Assume that you are having data in A column like the below:-

A1 cell
ABC

A2 cell
Abc

Paste this formula in B1 cell
=IF(EXACT(A1,UPPER(A1)),LOWER(A1),A1)

Now copy the B1 formula and paste it to B2 cell.

The result will be

B1 cell
abc

B2 cell
Abc

The above formula will convert the text to lower case only if the cell
consist the characters in Upper case. It will get the same result when the
text entry is in Proper OR Lower case.

Remember to Click Yes, if this post helps!
 
M

Ms-Exl-Learner

Assume that you are having data in A column like the below:-

A1 cell
ABC

A2 cell
Abc

Paste this formula in B1 cell
=IF(EXACT(A1,UPPER(A1)),LOWER(A1),A1)

Now copy the B1 formula and paste it to B2 cell.

The result will be

B1 cell
abc

B2 cell
Abc

The above formula will convert the text to lower case only if the cell
consist the characters in Upper case. It will get the same result when the
text entry is in Proper OR Lower case.

Remember to Click Yes, if this post helps!
 

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

Top