When I use this formula to import data=iferror(INDEX(IMPORTHTML(http://www.thestreet.com/quote/GE/details/company-profile.html,table,3),8,1))The result is Sector: Industrial Goods. I'd like to use the LEFT function to remove the Sector: text and show only Industrial Goods. I can't seem to get the syntax right. I can use this formula to show the length of the string:=len(iferror(INDEX(IMPORTHTML(http://www.thestreet.com/quote/GE/details/company-profile.html,table,3),8,1)))But can't figure out how to incorporate the LEFT function to get my result.
Google Sheets LEFT function trim text generated by IMPORTHTML function
google spreadsheets