Trim

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

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
 
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
 
Hi Jim
Try this :
=LEFT(A6,FIND("-",A6,1)-1)
Assuming your data is in A6, change to your needs.
HTH
John
 
Back
Top