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...
Thanks QuadruplePawn.
Is there a way to make this functional in a table? I kept getting a #Spill and #Value error.
How did you populate column E with the stripped Titles?
Is there a way to make this functional in a table? I kept getting a #Spill and #Value error.
How did you populate column E with the stripped Titles?
=IFERROR(INDEX($C$2:$C$8,MATCH(TRUE,ISNUMBER(SEARCH($C$2:$C$8,A2)),0)),"")This is the formula i entered in cell E2 (the screenshot is in an earlier post). I had to enter the formula with ctrl+shift+enter because this wasn't done in Office365 or 2021.
I tried this with a dynamic table and it returned the expected results.