Excel character swap formula needed

Job ID: 33929851

Budget: $30 – $250 USD

I've attached a screenshot of the character/number swap needed.

I need the formula for the two types of rows, and then I can copy/paste it for 100's of rows.

Number to be swapped Original - Swap red position Output
1 PP-02-001-BatchStatus PP-02-001-BatchStatus
1 PP-02-001-Run PP-02-001-Run
2 PP-02-001-BatchStatus PP-02-002-BatchStatus
2 PP-02-001-Run PP-02-002-Run
3 PP-02-001-BatchStatus PP-02-003-BatchStatus
3 PP-02-001-Run PP-02-003-Run
4 PP-02-001-BatchStatus PP-02-004-BatchStatus
4 PP-02-001-Run PP-02-004-Run
5 PP-02-001-BatchStatus PP-02-005-BatchStatus
5 PP-02-001-Run PP-02-005-Run

100's more …......
Related categories: Excel Mathematics