Hi all,
I don't know if anyone can quickly help with this, but is there a way of extracting just the text between two brackets ()?
I have a messy spreadsheet that is largely free text and I only need the ID's that are always between two brackets. There are several sheets to search through, so the soloution will have to search the whole workbook.
Many thanks for any help.
I don't know if anyone can quickly help with this, but is there a way of extracting just the text between two brackets ()?
I have a messy spreadsheet that is largely free text and I only need the ID's that are always between two brackets. There are several sheets to search through, so the soloution will have to search the whole workbook.
Many thanks for any help.