Chip Pearson has a nifty little Add-in called Cell Viewer which is what I use
............... available at www.cpearson.com

Vaya con Dios,
Chuck, CABGx3




"Jim May" wrote:

I've just imported 200 lines of test, most of which are
followed by the "small square box" which I interpret to
mean the "return-key", or the like.

Using an If statement, how do I identify the "character"?

=If(right(a1,1)= ? , left(a1,len(a1)-1),a1)

Thanks in advance...