Forum Discussion
Solved
Extract a portion of text
Hi. For the life of me, I can't work out the formula to extract a portion of text before and after a text delimiter. Column A - First part of text in cell only - SOLVED Column B - Raw Data Column...
Simon_Fish To extract the text between two delimiters you need to combine TEXTBEFORE and TEXTAFTER.
Try this in column C:
=TEXTBEFORE(TEXTAFTER(B5," - ")," - ")
Not sure I understand how the COUNTIF formula can return any other value than FALSE. In your example, the first formula returns 001 in case "Entity^" exists and an #N/A error if it doesn't. Then, I would wrap the formula in IFERROR like this:
=IFERROR(TEXTBEFORE(TEXTAFTER(AH14,"Entity^"),"^"),"")