I want to know if there is a formula to extract a complete string containing 'xxx' between two spaces.
For example:
CodePudding user response：
use:
=ARRAYFORMULA(IFNA(REGEXEXTRACT(A1:A; "\[\S*xxx\S*\]")))
I want to know if there is a formula to extract a complete string containing 'xxx' between two spaces.
For example:
CodePudding user response：
use:
=ARRAYFORMULA(IFNA(REGEXEXTRACT(A1:A; "\[\S*xxx\S*\]")))