How to turn M (For Millions) and B (For Billions)?

[rebel123]

Thanks for your help.

File is here

easyupload.io

easyupload.io

easyupload.io

The image below shows the correct answers (in green).
I just need an equals sign equation, please.

 

[Joe4]

A few different ways to do it.

For a value in cell B1, try this formula:

=MID(B1,2,LEN(B1)-3)*LET(x,LEFT(RIGHT(B1,2),1),IF(x="M",1000000,IF(x="B",1000000000,1)))

Or try this one, which is a little shorter/simpler:

=SUBSTITUTE(SUBSTITUTE(B1,"M+","000000"),"B+","000000000")+0

 

[rebel123]

Works Perfectly. Thanks.