Trim/Format Problem

[sand112281]

I need some help with trimming/formating some information. I downloaded bond ratings from a website and it returned the ratings and the credit outlook for the bond. eg. AA- *-, BBB- *+, or just AA-, BBB+. The information is in columns with the rating next to the company name. What I want is just the credit outlook for the bonds ( *- or *+ or 0) or some number/symbol to show if it is a positive, negative nor no outlook.
Eg.


Name Rating Outlook
Ford A *+ +
GM A 0
Exxon BBB *- -

Thanks for any help.

 

[Tazguy37]

Please check and make sure I've created the table correctly -- it's a bit hard to tell which stuff is in which columns when written out in text like that.

updatelinkstest.xls
	A	B	C	D
1	Name	Rating	Outlook
2	Ford	A+	+
3	GM	A	None
4	Exxon	BBB-	-
Sheet2

Formula in C2 (copied down) is:
=VLOOKUP(RIGHT(B2,1),{"+","+";"-","-";"A","None";"B","None";"C","None";"D","None"},2,0)

Yep, that's all one line. All you formula gurus out there: Is there a shorter way to do this? And any way to mask the #N/A if you enter something like "h"?
Anyways, hope that helps!