try the Left and Mid functions as :

from your example 621-03
to extract 6, use =LEFT(B2) in C2
to extract 2, use =MID(D18,2,1) in D2
change the above formula's argument from 2 to 3 to extract 1 in E2
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"sabow71" wrote:

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?