Extract complete string containing 'xxx' between two spaces

115 Views Asked by At

I want to know if there is a formula to extract a complete string containing 'xxx' between two spaces.

For example: example sheet

1

There are 1 best solutions below

0
On BEST ANSWER

use:

=ARRAYFORMULA(IFNA(REGEXEXTRACT(A1:A; "\[\S*xxx\S*\]")))

enter image description here