Regex to remove text from string
Hi, I am trying to remove specific text from a string using regex. The cell contents contain one or more items separated by commas with "not detected" at the end. I'd like to remove "not detected" to leave just the items listed that can be split by the comma. What I am using: Regex( Substitute( :"DETAILS"n, "not detected", "" ), "\S*" ) However, this appears to be truncating the list wherever the...