Prev: Counting consecutive numbers in a list
Next: How do I get my data back in excel after hiting F11 by mistake?
From: Ms-Exl-Learner on 12 Jan 2010 11:38
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!

--------------------
(Ms-Exl-Learner)
--------------------


"JB" wrote:

> 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??
First  |  Prev  | 
Pages: 1 2
Prev: Counting consecutive numbers in a list
Next: How do I get my data back in excel after hiting F11 by mistake?