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

Ask Excel and it will tell you. If it's the right most character you're
interested in, and one of your text lines is in A1, then enter:

[B1] = code(right(A1,1))

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

Bill,
Your're right - forgot to "think one step further".
Got it going here with:

=IF(CODE(RIGHT(H1,1))=13,LEFT(H1,LEN(H1)-1),H1)


"Bill Martin" wrote:

Ask Excel and it will tell you. If it's the right most character you're
interested in, and one of your text lines is in A1, then enter:

[B1] = code(right(A1,1))

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

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