Sep 17 2021 02:46 AM
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.
Sep 17 2021 03:00 AM
@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.
Sep 17 2021 03:19 AM