Filter a column for entries starting with capital letters

%3CLINGO-SUB%20id%3D%22lingo-sub-2759724%22%20slang%3D%22en-US%22%3EFilter%20a%20column%20for%20entries%20starting%20with%20capital%20letters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2759724%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20hide%20all%20entries%20in%20a%20column%20(except%20the%20header)%20which%20do%20not%20begin%20with%20a%20capital%20letter%2C%20i.e.%20the%20symbols%20A%2C%20B%2C%20C%2C%20...%2C%20Z.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20would%20I%20do%20that%20with%20a%20VBA%20macro%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2759724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2759777%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20a%20column%20for%20entries%20starting%20with%20capital%20letters%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2759777%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1154117%22%20target%3D%22_blank%22%3E%40jukhamil%3C%2FA%3E%26nbsp%3BYou%20could%20add%20a%20helper%20column%20to%20the%20table%20and%20use%20a%20formula%20to%20determine%20if%20the%20CODE%20of%20the%20first%20character%20is%20between%2065%20(%3Dcapital%20A)%20and%2090%20(capital%20Z)%2C%20resulting%20in%20TRUE%20or%20FALSE.%20Then%20filter%20to%20show%20only%20TRUE.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I would like to hide all entries in a column (except the header) which do not begin with a capital letter, i.e. the symbols A, B, C, ..., Z.

 

How would I do that with a VBA macro?

 

Thank you very much.

2 Replies

@jukhamil You could add a helper column to the table and use a formula to determine if the CODE of the first character is between 65 (=capital A) and 90 (capital Z), resulting in TRUE or FALSE. Then filter to show only TRUE. See attached.

Thanks very much. I'd like to use this CODE syntax to determine if a cell begins with a capital letter or not. But I'd rather just apply a filter based on that condition, in VBA. So I'll keep looking into how to do that. Thank you very much for your insight