Text Search

marquez313

New Member
Joined
Mar 10, 2009
Messages
18
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!
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

JamesW

Well-known Member
Joined
Oct 30, 2009
Messages
1,197
Hi there,

Not very pretty, but try:

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

Watch MrExcel Video

Forum statistics

Threads
1,109,462
Messages
5,528,942
Members
409,848
Latest member
Blomsten
Top