How to Extract Text Before or After a Specific Character in a String in Excel - Office 365

You can extract text before or after a specific character in Excel using a combination of functions TRIM, LEFT, RIGHT, LEN , SEARCH and FIND. This video gives the formulas to use to retrieve text from a Cell.

[ryant]

Thank you! I have a question: how do you apply this to cells of a larger range that only contain values? Cells that do not contain values come up as “###…” and I can’t average the range including the hashtags.

[alexbadgal]

Hey, how do I extract “abc def” if I have for example c_12345 abc def? What Formula should I use to remove whole c_12345? + in case I have more or less numbers after _? Thanks

[eqeqbtx]

HI, i am struggling to only extract the name before the `\n` character ... 123 CONSTRUCTION\n\nMAIN TRADE: \nBUILDER\n\nBASED IN: \nTOWN NAME\n\nCERTIFICATION: \n \n\nJOINED: \n.. I only want to extract 123 CONSTRUCTION. Please can you help me?

[LAZARSELVA]

Eg:how to use FIND and SEARCH functions

in the above line, how to extract the word ending with "RCH" and also its previous word?

Result should be : (and SEARCH)