How do i find and filter capitalized text?

[EAB007]

Hi, i have a spreadsheet with over 20K lines about 500 of them are with capitalized text.


I need to find or filter those lines so i can use the "=PROPER(A1)" formula.


How do i do that?

 

[EAB007]

* And without using the "=PROPER(A1)" formula for the entire data.

 

[Hui]

Eab007


Firstly welcome to Chandoo.org Forums


If it is just the first character of your text you want to cehck for capitalisation

You can use something like this

=IF(CODE(A2)>96,PROPER(A2),A2)


or If you want to sort them

=If(Code(A2)>96,"Lower","Upper") and then sort by this new field