I have a large spreadsheet with site specific information on multiple buildings within the same site.

Each piece of equipment has a unique asset number eg 0123-456-789-001(all contained in a single cell).

Each number means something different 0123(site)-456(building number)-789(asset description)-001(equipment number)

I need to create a formula to count the number of buildings within the site.

For example:

Asset Numbers:
0123-456-789-001
0123-654-789-001
0123-123-789-001

If this was the data I was analysing I want to look at the second group of numbers(being the building number) to access how many building there are. In this case there is three different buildings and that is the outcome I need from the formula.

Any help would be appreciated.