Formula
 

Can some one please help me with a formula? I have several hundred rows in
the same column with the numbers HI0375xxxx. I need to formula to change
that to HI375xxx and take out all the zeros. The numbers vary in the rows
after the "0", but the "0" is always the 3rd charactar. Thank you for anyone
that can help.

Formula
 

Hi,

Try this and then if you want you can copy and paste special paste values
back over the original data

=LEFT(A1,2)&MID(A1,4,LEN(A1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mmmalaska" wrote:

Can some one please help me with a formula? I have several hundred rows in
the same column with the numbers HI0375xxxx. I need to formula to change
that to HI375xxx and take out all the zeros. The numbers vary in the rows
after the "0", but the "0" is always the 3rd charactar. Thank you for anyone
that can help.

Formula
 

Mike,

Thank you so much. It worked like a charm. Have a good one

Mark

"Mike H" wrote:

Hi,

Try this and then if you want you can copy and paste special paste values
back over the original data

=LEFT(A1,2)&MID(A1,4,LEN(A1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mmmalaska" wrote:

Can some one please help me with a formula? I have several hundred rows in
the same column with the numbers HI0375xxxx. I need to formula to change
that to HI375xxx and take out all the zeros. The numbers vary in the rows
after the "0", but the "0" is always the 3rd charactar. Thank you for anyone
that can help.

Formula
 

Your welcome


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mmmalaska" wrote:

Mike,

Thank you so much. It worked like a charm. Have a good one

Mark

"Mike H" wrote:

Hi,

Try this and then if you want you can copy and paste special paste values
back over the original data

=LEFT(A1,2)&MID(A1,4,LEN(A1))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"mmmalaska" wrote:

Can some one please help me with a formula? I have several hundred rows in
the same column with the numbers HI0375xxxx. I need to formula to change
that to HI375xxx and take out all the zeros. The numbers vary in the rows
after the "0", but the "0" is always the 3rd charactar. Thank you for anyone
that can help.