I’m using the Search function to locate where I want to extract text using the Left String function, I just don’t know how to combine the two functions. For example within one row of data there’s text with multiple delimiters within the string. Search finds the second delimiter correctly. Now I want to grab the text that precedes the delimiter.
Hallo
if, for example your delimiter is a ,comma:
=REGEX(A1;"^([^,]+,[^,]+),.*$";"$1")