Change numbers from an specific cell

[Manuel Casal]

Hello all,

I need to modify one excel format number from an specific cell and write it in a different cell.
For example, I have number 787122005 and need the following format in another cell.

12_000_2005_000

It would be, digits numbers 4,5 (12) following _000, then digit numbers 6,7,8,9 (2005) following for _000
Can you help me with a formula to get this format?

Thanks!!

[Pete_UK]

Try this in B2, assuming your original number is in cell A2:

=MID(A2,4,2)&"_000_"&RIGHT(A2,4)&"_000"

Hope this helps.

Pete

[TMS]

Try:

Please Login or Register  to view this content.

[Manuel Casal]

Yes, that worked
Many thanks Pete

[Pete_UK]

You're welcome.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete