Text Search

[marquez313]

I'm trying to convert this:
<table border="0" cellpadding="0" cellspacing="0" width="180"><col width="180"><tr height="17"> <td class="xl63" style="height: 12.75pt; width: 135pt; font-size: 10pt; color: black; font-weight: 400; text-decoration: none; font-family: "Arial Narrow"; border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: white white white -moz-use-text-color; background: none repeat scroll 0% 0% rgb(184, 204, 228);" width="180" height="17">BankAm (BAC)</td> </tr></table>
To this:
BAC

However, the symbols are not consistently 3 letters. They range between 1-4 letters, typically. The only consistent thing is the parenthesis. I've tried a combination of right and left commands, but can't figure out how to get rid of the parenthesis. Thanks!

 

[JamesW]

Hi there,

Not very pretty, but try:

=MID(A1,SEARCH("(",A1,1)+1,SEARCH(")",A1,1)-SEARCH("(",A1,1)-1)

 

[marquez313]

"Not very pretty, but it works" is my motto. Thanks!