如何在Google Sheets中移除IMPORTHTML函数输出数据中的星号（*）

Got it, let's fix this. To strip all asterisks (*) from the data your IMPORTHTML formula pulls, you just need to nest it inside a SUBSTITUTE function—this will replace every instance of the asterisk with an empty string, effectively removing them entirely.

Here's the full working formula: #

=SUBSTITUTE(IMPORTHTML("https://niftyinvest.com/option-chain/BAJFINANCE?expiry=26MAY2022","Table",1),"*","")

How it breaks down: #

• IMPORTHTML(...): This part does the original work of fetching the table from the specified URL.
• SUBSTITUTE(data_to_clean, "*", ""): The outer function takes the raw table data, finds every occurrence of *, and replaces it with nothing (the empty string "").

This will clean all asterisks from every cell in the imported table automatically.

内容的提问来源于stack exchange，提问作者Brijesh