How to Nest =MID(A1,2,LEN(A1)-2) To Eliminate Quotation Marks

[blafarm]

I am trying to remove the double quotation marks from the front and back of the result of this API call:

=IF(A1="","",IFERROR(WEBSERVICE("https://api.iextrading.com/1.0/stock/"&A1&"/quote/companyName"),""))

Where the contents of A1 are any stock symbol, like AMZN

The API call works perfectly, but I can't seem to figure out how to nest this function: =MID(A1,2,LEN(A1)-2) to eliminate the quotation marks.

I would be grateful for any guidance.

Thank you.

 

[blafarm]

I've simplified my formula to this:

=IF(A1="","",(WEBSERVICE("https://api.iextrading.com/1.0/stock/"&A1&"/quote/companyName")))

But I still cannot figure out how to nest: =MID(A1,2,LEN(A1)-2)

 

[mikerickson]

Would =SUBSTITUTE((WEBSERVICE("https://api.iextrading.com/1.0/stock/"&A1&"/quote/companyName"), CHAR(34), "") do what you want?

 

[blafarm]

Thank you very much.

After a bit of experimentation, I found this works for me:

=IF(A1="","",SUBSTITUTE(WEBSERVICE("https://api.iextrading.com/1.0/stock/"&A1&"/quote/companyName"),CHAR(34),""))

I really do appreciate you taking the time to help me.

Thanks again very much !!!