Remove trailing space

[NusratRahman]

I am comparing two names column(A&B) I using

=IF(A1=B1,0,1) or Exact(A1,B1) But in every case my
results comes false because even though the two coulms
have same value but their lenths are difference.

Q: How to remove trailing space to both coulm have same
lentgh.

Thanks.

 

[Peo Sjoblom]

Try

=IF(TRIM(A1)=TRIM(B1),0,1)

if that doesn't work then you don't have trailing spaces but most likely
trailing HTML characters
then try

=IF(SUBSTITUTE(TRIM(A1,CHAR(160),""))=SUBSTITUTE(TRIM(B1,CHAR(160),"")),0,1)

 

[Dave R.]

If it's a trailing space, try

=EXACT(TRIM(A1),TRIM(B1))

 

[Arvi Laanemets]

Hi

=((TRIM(A1)=TRIM(B1))*1

 

[Frank Kabel]

Hi
try
=Exact(TRIM(A1),TRIM(B1))

 

[David McRitchie]

My choice for trimming spaces and/or CHAR(160) would be with
a macro see TRIMALL macro at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
which would work on a reselected area(s).

You can select entire columns before invoking the macro.