Count specific characters with numbers or letters

I have hundreds of spreadsheets with information broken into sections. These sections are all classified by a "title" such as "A-1" or "WC-2" or "P-3", etc. I need to count how many "sections" there are so I would like to count how many "titles" are on one spreadsheet. Can anyone help me?

Hello Hoppscrouse.

This macro will return total number of "titles" on the worksheet. For the "title" to be considered valid it must have the following format:

1. The left side of the hyphen must have at least one upper case letter A - Z
   
2. The right side must have at least one number 0 - 9

Paste this code into a Standard VBA Module

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Right Click on any Sheet's tab
4. Left Click on View Code in the pop up menu
5. Press the keys ALT+I to activate the Insert menu
6. Press M to insert a Standard Module
7. Paste the code by pressing the keys CTRL+V
8. Make any custom changes you need to the macro
9. Save the Macro by pressing the keys CTRL+S

Sincerly,
Leith Ross

=COUNTIF(A:IV,"*?-?*") will return the number of cells that have a hyphen, but do not begin or end with a hyphen.

Leith, Thank you so much. This is awesome!!!

Originally Posted by Leith Ross

Hello Hoppscrouse.

This macro will return total number of "titles" on the worksheet. For the "title" to be considered valid it must have the following format:

1. The left side of the hyphen must have at least one upper case letter A - Z
   
2. The right side must have at least one number 0 - 9

Paste this code into a Standard VBA Module

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Right Click on any Sheet's tab
4. Left Click on View Code in the pop up menu
5. Press the keys ALT+I to activate the Insert menu
6. Press M to insert a Standard Module
7. Paste the code by pressing the keys CTRL+V
8. Make any custom changes you need to the macro
9. Save the Macro by pressing the keys CTRL+S

Sincerly,
Leith Ross