Below is just showing an example on what I need to do
I need col D & E to look like H & I results
I just need column D's numbers to go after Column E's word one space and then the number.
Any help thank you
Excel 2016 (Windows) 32 bit
I need col D & E to look like H & I results
I just need column D's numbers to go after Column E's word one space and then the number.
Any help thank you
Excel 2016 (Windows) 32 bit
C | D | E | F | G | H | I | |
---|---|---|---|---|---|---|---|
1 | orignal | Union Local | Union Name | Results | Union Local | Union Name | |
2 | 20 | Local | 20 | Local 20 | |||
3 | 20 | Local | 20 | Local 20 | |||
4 | 6,18A,20 | Local | 6,18A,20 | Local 6,18A,20 | |||
5 | 20 | Local | 20 | Local 20 | |||
6 | 20 | Local | 20 | Local 20 |
Sheet: Sheet1 |