View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim May
 
Posts: n/a
Default Elimination of "box character" at end of test line

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...