Convert Volume From a Stock Formula- Number (Leave Alone) K = 1,000 and M = 1,000,000

[rebel123]

Please respond with an equals sign answer that I can drag down.
Correct answers are in green.

 

[rebel123]

PHOTO

 

[rebel123]

file is here-

Google Sheets: Sign-in

Access Google Sheets with a personal Google account or Google Workspace account (for business use).

docs.google.com

 

[Fluff]

Your title suggests you could have values that end in K & M, but you have not shown that in your data.
Please post realistic data to the site, not an image or a link.

 

[rebel123]

Sorry that was the wrong image!

 

[rebel123]

The file is here- not sure if the link words- https://docs.google.com/spreadsheet...ouid=110851774971614912946&rtpof=true&sd=true

 

[Fluff]

I asked

Please post realistic data to the site, not an image or a link.

Please do so.

 

[Phuoc]

Try this:

Book1
	A	B
1	331	331
2	4.01K	4,010
3	1.05M	1,050,000
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=--SUBSTITUTE(SUBSTITUTE(A1,"K","E3"),"M","E6")

 

[rebel123]

I asked

Please do so.

I was told in previous posts by admin to post the file. Now, I post the file in the link and I am told to NOT do that.
I do not think this site has an option for me to upload the Excel file, and I was told to put the file on Google Drive-
which I did. Please clarify.

 

[rebel123]

Thanks Ph

Try this:

Book1
	A	B
1	331	331
2	4.01K	4,010
3	1.05M	1,050,000
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=--SUBSTITUTE(SUBSTITUTE(A1,"K","E3"),"M","E6")

Thanks. Works great. I marked it as resolved!