Extract Multiple Text

B Diamond

Hi all,

I have a drop-down list that has multiple selections, and I want to extract all of the text within parentheses into one cell.

Greatly appreciated if anyone can help.

Leibel S

@B Diamond

How do you want to show it extracted.

One way this can be done is you have a separate list of all these 'Z numbers' on another sheet.

then on this sheet you use the formula below (change cross sheet reference as needed):

=JOIN(COLLECT({cross sheet to list}, {cross sheet to list}, CONTAINS(@cell, Codes@row)), " ")

This will just bring them in separated by a space.

You may need to add on this other sheet a column with the parentheses (to avoid bringing back partial matches):

=JOIN(COLLECT({cross sheet to list}, {cross sheet to list with parentheses}, CONTAINS(@cell, Codes@row)), " ")

Leibel S

@B Diamond

How do you want to show it extracted.

One way this can be done is you have a separate list of all these 'Z numbers' on another sheet.

then on this sheet you use the formula below (change cross sheet reference as needed):

=JOIN(COLLECT({cross sheet to list}, {cross sheet to list}, CONTAINS(@cell, Codes@row)), " ")

This will just bring them in separated by a space.

You may need to add on this other sheet a column with the parentheses (to avoid bringing back partial matches):

=JOIN(COLLECT({cross sheet to list}, {cross sheet to list with parentheses}, CONTAINS(@cell, Codes@row)), " ")

B Diamond

@Leibel S

This is exactly what I was looking for! Thanks a lot!

Leibel S

If you need to do something a bit more complicated then you can use the below examples:

https://community.smartsheet.com/discussion/86237/extract-multiple-pieces-of-a-text-string-that-meet-a-criteria-between-parentheses

https://community.smartsheet.com/discussion/84210/find-max-and-min-values-in-one-cell