Here’s my problem:
I have about 700 cells I want to interrogate.
Within each cell the following text appears “Estimate – BOLB/02/1234 – Some more text here”
I want to search all the cells and delete the cell contents but leave the “BOLB/02/1234”.
The problem I have is that the string is different in each cell but the format is the same. It always starts with BOLB followed by /, followed by 2 numbers, followed by / followed by 4 numbers i.e. BOLB/**/****.
I am struggling to find a solution to this
Thanks for any help in advance!
Bookmarks