Trim
 

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

Trim
 

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

Trim
 

Have a look in the help index for LEFT
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jim" wrote in message
...
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

Trim
 

With the data in A1, use this formula:


=LEFT(A1,FIND("-",A1,1)-1)

Trim
 

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