'How can I remove $ from imported html

I'm using the following code.

=(index(IMPORTHTML(concat("https://coinmarketcap.com/currencies/","bitcoin"),"table",1),1,2))

I would like to multiply with the number, however, I can't do that since it is treated as text.

Does any have any clue how I can remove the $?



Solution 1:[1]

use:

=INDEX(REGEXREPLACE(IMPORTHTML(
 "https://coinmarketcap.com/currencies/"&"bitcoin", 
 "table", 1), "[\$,]", )*1, 1, 2)

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0