Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|