Short Answer
#Short Answer InsteadInstead of LEFT() use RIGHT().
#Explanation
Explanation
The LEFT() function returns the leftmost characters, but the OP want to get the rightmost characters.
The following is a simplified version of the final formula, for explanatory purposes:
=RIGHT("Sector: Industrial Goods",16)
The following is the final formula; in order to improve readability, each parameter is inserted in a new line:
=RIGHT(
iferror(
INDEX(
IMPORTHTML(
"http://www.thestreet.com/quote/GE/details/company-profile.html",
"table",
3
),
8,
1
)
),
16
)