Excel 2024: Text Before or After a Specific Delimiter
October 15, 2024 - by Bill Jelen
The new TEXTBEFORE
and TEXTAFTER
functions debuted on March 16, 2022 for Microsoft 365 Insiders. These functions isolate the text before or after a specific delimiter.
The function syntax requires some text and the delimiter. Optional arguments: instance_num for which delimiter, match_mode for case sensitive, match_end prevents an #N/A if the delimiter is not found. TEXTBEFORE("Cher"," ")
returns #N/A. =TEXTBEFORE("Cher"," ",,,1)
returns Cher.