I manage a strength report for my employer that accounts for each employee
using a unique number assignment system. This system is designed to allow me
to identify which of nine teams an employee belongs to, identifying their
specific assignment within that team and also their employment status (i.e.,
contractor, intern, volunteer).

For example, I am 621-03. The "6" indicates which team I am on. The "2"
identifies my assignment (Quality Assurance). And the "1" indicates
employment status.

My strength report needs to provide an accountability breakdown for teams
and broken down further by employment status. Is there a function that can
extract a specific digit/character from a cell entry?

Currently, I am specifying cell ranges for each group. As the organization
expands, this will present an accuracy problem as valid cells are possibly
excluded from count.

How do I do this?