Calculation Question (3 Different Sequences)

[rebel123]

Calculation Question (3 Different Sequences)

Please provide the formula starting with an = sign that I can drag down.
Seeking the answers in the green highlighted areas. The green area has the
correct answer. I am simply deleting the first 2 digits of each sequence,
but I do not know the formula.

Thanks!

 

[Joe4]

If the value were in cell E10, and you want the result in cell F10, use this formula in cell F10:

=MID(E10,3,LEN(E10)-2)

 

[rebel123]

awesome works like a charm! Thanks man!

 

[Joe4]

You are welcome.

I hope in looking at the formula, you can understand how it works/what it is doing. If you have any questions about it, please let us know.

 

[rebel123]

It was very easy. I just substituted the E10 with M699 since I was on cell M699.
You could not tell from my screenshot, because it did not show the cell numbers.

It worked perfectly. Thanks!!!