Extracting set of values from text

[ToxicBuoy]

Hi,

Thanks for your response in advance.

I have a usecase where I need to extract a set of texts from list of larger cluster of text like below:

Extract all AB, CDE, FG, HIJ, KL from the below column.

1. AB needs to be assigned

2. the work is with CDE

3. FG will assign it to AB, KL to handover process

4. HIJ to confirm AB on role

5. CDE unsure on data accuracy, FG sure on data accuracy

for the above output values should be:

1. AB

2. CDE

3. FG,AB,KL

4. HIJ,AB

5. CDE, FG

[ToxicBuoy]

Thanks @pedrodrfaria for that.