I have cell contents that are like this:
AX/RA/CMB
The format always has 2 x "/" with letters to the left, middle, and right of the "/" , however the number of letters in the text bit varies. Some are 2 digits, some 3 and some more.
e.g. AB/CD/EF or ABC/DEF/GHI or AB/CDE/FG
I would like to use VBA to change the current cell contents so that the cell displays the middle letters, that is the bit in between the "/" and "/"
Hopefully you can help!
AX/RA/CMB
The format always has 2 x "/" with letters to the left, middle, and right of the "/" , however the number of letters in the text bit varies. Some are 2 digits, some 3 and some more.
e.g. AB/CD/EF or ABC/DEF/GHI or AB/CDE/FG
I would like to use VBA to change the current cell contents so that the cell displays the middle letters, that is the bit in between the "/" and "/"
Hopefully you can help!