how to display partial data from linked source

Newbie question:
I’m pulling in crypto current prices from CoinGecko into cells, eg

These return results such as
I want to display only 41900.
How please? I tried this “REFIND” solution
but not luck. thanks.

1 Like

My workaround was the following. In an adjacent cell I put in:


Where O5 is the cell importing the API.

For some reason this REGEX… was not recognized as a digit, so in a THIRD adjacent cell:


Where P5 is the REGEX… cell. This now accepts number-formats (currency, etc.)

Inelegant I’m sure, but it works!

You can involve the REGEX with VALUE, =VALUE(REGEX((O5),"-?\d+(.\d{1,5})?")) to avoid another cell.

1 Like