On the current worksheet I got hundreds of hyperlinks
The text to display of these hyperlinks are as follows:
So some of them may have the '_REV_X' missing.
For the selected cells I would like to run a macro that eliminates this part (i.e. the '_REV_X' part) and just leaves the number as 'text to display'.
In the above example after running the macro the 'text to display'' for these hyperlinks would look like as follows:
Help is very much appreciated. Thank you very much in advance.