Actually I made a mistake. And it was not a space issue.

A1 contains the following:

=INDEX($D$1:$D$700,R15)

and it returns the "<".

If I use an IF function that says =IF(A1="<","Curly","Larry") I
get Larry.

How can I fix this so that when I reference Cell A1 I get Curly.


Thanks,


Gary