• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do i find and filter capitalized text?

EAB007

New Member
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


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
 
Back
Top