'When using IMPORTHTML, how do i breakup the return data and only receive certain info?
I am using this formula to receive data in A3.
=importhtml("https://www.finviz.com/quote.ashx?t="&$A$3,"Table",5)
Which returns:
GOOGL[NASD]
Alphabet Inc.
Communication Services | Internet Content & Information | USA
My question is how do I edit the formula where all I receive is the Communication Services?
I have tried using split function with it but I am not familiar enough with it to know how to input properly.
Solution 1:[1]
Use INDEX to select specific elements in the list returned by IMPORTHTML, and SPLIT to split the last element between |:
=INDEX(SPLIT(INDEX(IMPORTHTML("https://www.finviz.com/quote.ashx?t="&$A$3,"Table",5),3),"|"),1)
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 | Iamblichus |