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