I have the following formula to pull in the name of a stock based on the given Ticker Symbol...
=SUBSTITUTE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s="&A2&"&f=n"),CHAR(34),"")
It returns this when I have the corresponding ticker symbol plugged in:
Hewlett-Packard Company Common
I would like to be able to get rid of the word "Common" if that is possible.