Removing more than one symbol in importhtml data output-CodePudding

Home > OS > Removing more than one symbol in importhtml data output

Removing more than one symbol in importhtml data output

Time：06-15

I tried following formula..... =ARRAYFORMULA(SUBSTITUTE(IMPORTHTML("https://niftyinvest.com/option-chain/BAJFINANCE","Table",1)and was able to get the data but with two symbols - and *. Now I want to remove * and - symbol to be replaced by zero. How to do that plz ???

CodePudding user response：

Try the following formula:

=ARRAYFORMULA(SUBSTITUTE(SUBSTITUTE(IMPORTHTML("https://niftyinvest.com/option-chain/BAJFINANCE","Table",1),"-", "0"), "*", ""))

Page link：https//www.codepudding.com/os/442134.html

Prev:Split text data into one column for several rows in Google Sheets/Excel

Next:Google Sheets collect data from two sheets

Tags：

google-sheets

Links：
CodePudding