Forum Discussion
EXTRACT text String
Good Afternoon How can I extract common titles from a text string in an Excel cell, copy the title to another cell, remove the title from the original text string? As an example, I have about 15 com...
=IF(ISNUMBER(MATCH(TRUE,ISNUMBER(SEARCH($C$2:$C$8,A2)),0)),TRIM(SUBSTITUTE(A2,INDEX($C$2:$C$8,MATCH(TRUE,ISNUMBER(SEARCH($C$2:$C$8,A2)),0)),"")),A2)Is this what you are looking for? Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Thanks. I'll give it a go Quadruple Pawn. How did you get that UserName?