Excel character swap formula needed
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 …......
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 …......