TangySauce
New Member
- Joined
- Mar 25, 2021
- Messages
- 2
- Office Version
- 365
- 2019
- 2016
Hello everyone,
I hope some experts here could help me with either a formula or script for the following.
The data will exist in a single cell with square bracket delimiters([ ]). My goal is to scan the data and if the text contains a certain phrase, that data is than extracted to a specific cell within the same sheet.
I tried a few variations with IF conditions, ISNumber, MID, SEARCH, FIND, LEFT, RIGHT, etc... but can't quite get the extracts. Its been fun for the past 3 days playing with formulas, but I am at a point where I need help.
Below is a sample of the data:
I hope some experts here could help me with either a formula or script for the following.
The data will exist in a single cell with square bracket delimiters([ ]). My goal is to scan the data and if the text contains a certain phrase, that data is than extracted to a specific cell within the same sheet.
I tried a few variations with IF conditions, ISNumber, MID, SEARCH, FIND, LEFT, RIGHT, etc... but can't quite get the extracts. Its been fun for the past 3 days playing with formulas, but I am at a point where I need help.
Below is a sample of the data: