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," - ")," - ")
Simon_Fish To extract the text between two delimiters you need to combine TEXTBEFORE and TEXTAFTER.
Try this in column C:
=TEXTBEFORE(TEXTAFTER(B5," - ")," - ")
