Allow me to clarify a little more. I need hte digits preceeding the first
hyphen "-" the digits preceeding the hyphen can be as many as five or as
little as 1

"Jim" wrote:

Hello,

I have hundreds of accounts listed in a column that look like this:

02172-LIPOSCIENCE-02172

I need to pull out the first five digits from the column

02172

I cannot drop the first digit (zero), so I guess it would need to be trimed
As a text? Can someone help me with this formula?

Thanks so much