I have the follow data in Col A
I need a formula or macro to do the following
1) The years after notes must be extracted/copied to Col C & D in the same row
2) R R -each of these to be extracted/copied to Col C & D
I have manually extracted the data o sow what it should look like
It would be appreciated if someone could kindly assist me
I need a formula or macro to do the following
1) The years after notes must be extracted/copied to Col C & D in the same row
2) R R -each of these to be extracted/copied to Col C & D
I have manually extracted the data o sow what it should look like
Book2 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Notes 2020 2019 | 2020 | 2019 | |||
2 | R R | R | R | |||
Sheet1 |
It would be appreciated if someone could kindly assist me