I'm trying to extract the names of federal deputies on the Chamber's website with importxml
, eg:
=IMPORTXML("http://www.camara.leg.br/Internet/deputado/Dep_Detalhe.asp?id=5310518#";"/html/body/div[2]/div/div/div/div/div/div/div[1]/ul/li[1]")
The formula returns
<li><strong>Nome civil:</strong> JOSÉ GERALDO TORRES DA SILVA</li>
In two columns, but I only need the name after ":"
I tried ext.texto
but it did not work.