Hi!

The only "stand-out" difference between the 2 samples is
that one contains a "J" and one contains a "G".

Does J denote a municipal bond and G denote a corporate
bond?

If you could explain how to distinguish one from another
it should be relatively easy to find a solution.

Biff

-----Original Message-----
I need to define cusips in excel in an if/nested if
statement

Example

Cell A1=005482J86
Cell A2=0162483G9

How do i use and if/or logic statement to make a true
statement equal "Muni
bond" (cell b1) or "Corp Bond"(cell b2)

I cannot get excel to recognize any logic statement since
a cusip has
numbers and text!!

Please help!
Thanks in advance !!
.