Excel Formula: Check If First Letter in the Cell is Capital or not.

If you have huge data in excel and you want to know the first letter of the cell is capital or not, here is the formula.

=EXACT(LEFT(A2,1),UPPER(LEFT(A2,1)))

This formula will show True or False in the result. The true mean first letter is Capital and False mean first letter is small. Later you can arrange or sort your data on the bases of result to separate small letter data.

Loading...