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

ABB_SEARCHOPTION_CHK_SAMEFILE=Same search option

<tbody>
</tbody>

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
2	BB_SEARCHOPTION_LBLHEAD=Search now	BB_SEARCHOPTION_LBLHEAD	Search now
3	ABB_SEARCHOPTION_CHK_SAMEFILE=Same search option	ABB_SEARCHOPTION_CHK_SAMEFILE	Same search option

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet9​

Worksheet Formulas Cell Formula B2 =MID(A2,1, FIND("=",A2)-1) C2 =MID(A2,FIND("=",A2)+1,1000) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>