Hello everyone!
I kindly request help with writing a formula that would be able to recognize square brackets in the text, e.g. <472> and then search for what to replace this ID with. Let's assume that there can be up to six such IDs in one cell of the text. The IDs are available for reading in column D, while the value to be copied is in column F. I would like to use formulas for this, not a script.
Below is the link to the Google Sheet:
The formula is to be entered in B2 to B11.
I kindly request help with writing a formula that would be able to recognize square brackets in the text, e.g. <472> and then search for what to replace this ID with. Let's assume that there can be up to six such IDs in one cell of the text. The IDs are available for reading in column D, while the value to be copied is in column F. I would like to use formulas for this, not a script.
Below is the link to the Google Sheet:
Cooking - tests
docs.google.com
The formula is to be entered in B2 to B11.
Last edited by a moderator: