Extract text before/after a certain symbol?

[excelnoob18]

I tried several formulas I found online but they won't work. I have a huge list of strings like this:

ABB_SEARCHOPTION_LBLHEAD=Search now
[TABLE="width: 378"]
<tbody>[TR]
[TD="class: xl65, width: 378"]ABB_SEARCHOPTION_CHK_SAMEFILE=Same search option[/TD]
[/TR]
</tbody>[/TABLE]

Is there a formula to extract the text before (or after) the = symbol?

 

[DRSteele]

Welcome to the forum.

Assuming your search string has only one "=" character, this will extract the text before and after the "=" character. Performing a Text-to-Columns operation would work also. Copy B2 and C2 down as necessary.

	A	B	C
BB_SEARCHOPTION_LBLHEAD=Search now
ABB_SEARCHOPTION_CHK_SAMEFILE=Same search option

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]2[/TD]

[TD="bgcolor: #E2EFDA"]BB_SEARCHOPTION_LBLHEAD[/TD]
[TD="bgcolor: #E2EFDA"]Search now[/TD]

[TD="align: center"]3[/TD]

[TD="bgcolor: #E2EFDA"]ABB_SEARCHOPTION_CHK_SAMEFILE[/TD]
[TD="bgcolor: #E2EFDA"]Same search option[/TD]

</tbody>

Sheet9​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]=MID(A2,1, FIND("=",A2)-1)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=MID(A2,FIND("=",A2)+1,1000)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]