Return to Question

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.

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.