How to convert M for Millions and B for Billions

[rebel123]

Here is the spreadsheet. Last time, someone said they could not access it for some reason-

https://docs.google.com/spreadsheets/d/1yA33afG-GAsfYWtO9ArWiqyhwjVNvr1J/edit?gid=874132290#gid=874132290

So, I included an image as well. The correct answers are in green. I just need an = sign answer please.
Thanks!

 

[MARK858]

 

[RoryA]

One option:

=LEFT(C2,len(C2)-1)*IF(RIGHT(C2,1)="M",1000000,1000000000)

 

[MARK858]

Another option

Book2
	C	D	E	F	G
2	128.78M	10.045B		128780000	10045000000
Sheet4

Cell Formulas
Range	Formula
F2	F2	=SUBSTITUTE(C2,"M","")*1000000
G2	G2	=SUBSTITUTE(D2,"B","")*1000000000

 

[rebel123]

Thanks Rory that worked. Also thanks MARK858 for explaining the file share.

 

[Phuoc]

Or try this:

=--SUBSTITUTE(SUBSTITUTE(C2,"M","E6"),"B","E9")

 

[Cubist]

One more option that handles lower/upper case and other abbreviations.

Book1
	A	B
1
2	1.20k	1200
3	1.20K	1200
4	1.653M	1653000
5	1.653m	1653000
6	2.56B	2560000000
7	4.0T	4E+12
Sheet1

Cell Formulas
Range	Formula
B2:B7	B2	=--(LEFT(A2,LEN(A2)-1)&"e"&(3*SEARCH(RIGHT(A2,1),"kmbt")))