Office 365 Mac Excel 2011 numbers extracted from downloaded data sorts weird

[sdsaav]

Downloaded about 900 company stock market caps from Yahoo Finance the vast bulk of which is formatted like these examples:
[TABLE="width: 65"]
<tbody>[TR]
[TD="class: xl63, width: 65"]9.923B[/TD]
[/TR]
[TR]
[TD="class: xl63"]5.994B[/TD]
[/TR]
[TR]
[TD="class: xl63"]28.416B[/TD]
[/TR]
[TR]
[TD="class: xl63"]38.361B[/TD]
[/TR]
[TR]
[TD="class: xl63"]4.181B[/TD]
[/TR]
[TR]
[TD="class: xl63"]8.748B[/TD]
[/TR]
[TR]
[TD="class: xl63"]92.671B[/TD]
[/TR]
</tbody>[/TABLE]

I've tried a half-dozen solutions around the internet that have worked for others but that I can't get to work for me so I can format the entries to sort. The last was this: =IFERROR(MID($A2,SMALL(IF(MMULT(ABS(ISNUMBER(0+MID(MID(" "&$A2,ROW(INDIRECT("1:"&LEN(" "&$A2)-7)),8),{1,2,3,4,5,6,7,8},1))-{1,0,0,0,0,0,0,1}),{1;1;1;1;1;1;1;1})=8,ROW(INDIRECT("1:"&LEN($A2)-7))),COLUMNS($A:A)),6),"") [XOR LX

Board Regular here]
which returned a blank cell. Others have returned #N/A or [zero].
When I try to sort my simpler solutions [eg., replace "B" with ""] I get a bunch of weird non-numerical & mixed mini-sorts like at least some entries are still read as text [no apostrophes] or something. Any suggestions? Thanks in advance! Shawn

 

[mole999]

If you want these as number only my thoughts (maybe not what you want)

B remove with substitute(A1,"B","") or similar

if its a text number then --A1 will convert to numeric (double minus)

not sureof the best way to construct the two together