I am building a stock model - where I use =importhtml() to give me financial data pulled from a website on certain stocks. It is returning it correctly, but there are asterisks surrounding all the data as seen below:

• Ticker Market Cap Income
• *AAPL * *1151.68B * *57.53B *
• *ABT * *144.46B * *3.60B *
• *AMD * *58.17B * *328.00M * (no actual spaces are between asterisks - just avoiding HTML )

So I am taking that data and using =if(B3="-",0,mid(B3,2,LEN(B3)-2)) to get rid of the asterisks.

• Ticker Market Cap Income
• AAPL 1151.68B 57.53B
• ABT 144.46B 3.60B
• AMD 58.17B 328.00M

Thats working - but I want it to be able to recognize that there is either a "B" or an "M" at the end, take that char off and then multiply it by either a billion or a million, depending.

I can take my second asterisk-free table and then make a THIRD table using:

=if(right(B95,1) = "B",LEFT(B95,Len(B95)-1)*1000000000,if(right(B95,1) = "M", LEFT(B95,Len(B95)-1)*1000000))

That does the trick. But I would like figure out how to merge these two into one command so I don't have to make the third table.

Thanks

I am building a stock model - where I use =importhtml() to give me financial data pulled from a website on certain stocks. 
It is returning it correctly, but there are asterisks surrounding all the data as seen below:

Ticker       Market Cap      Income
 *AAPL*      *1151.68B*      *57.53B*
 *ABT*       *144.46B*       *3.60B*
 *AMD*       *58.17B*        *328.00M*

(no actual spaces are between asterisks - just avoiding HTML )

So I am taking that data and using =if(B3="*-*",0,mid(B3,2,LEN(B3)-2)) to get rid of the asterisks:

Ticker   Market Cap   Income
 AAPL     1151.68B    57.53B
 ABT      144.46B     3.60B
 AMD      58.17B      328.00M

That's working - but I want it to be able to recognize that there is either a "B" or an "M" at the end, take that char off and then multiply it by either a billion or a million, depending.

I can take my second asterisk-free table and then make a THIRD table using:

=if(right(B95,1) = "B",LEFT(B95,Len(B95)-1)*1000000000,if(right(B95,1) = "M", LEFT(B95,Len(B95)-1)*1000000))

That does the trick. But I would like figure out how to merge these two into one command so I don't have to make the third table.