trim

[Tejas Kokje]

Hi,
I am trying to compare two alphanumerical values from two different
columns after trimming them. But I guess something is not going wrong.
Can some body post simple code which compares values from two columns.

Regards,
Tejas Kokje

 

[Frank Kabel]

Hi
take a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon

 

[Rob]

Tejas,

The following assumes entries are in c2 and d2, the entry is trimmed then
converted to uppercase.
=EXACT(TRIM(UPPER(C2)),TRIM(UPPER(D2)))

Rob