Hello again, I have another query regarding extracting data from a text string.
Some of my data has brackets after it and some doesn't. Example in the sheet attached
In column A I have the data.
I would like a formula to extract in column B the fruit
And then in column C - the word within the bracket (Not including the bracket). If there is no bracket then put NA
Thanks for any help on this
Bookmarks