M

#### Madiya

same.

But excel thinks that the contents are different coz it giving error

in vlookup, arrey, if formulas.

I have tried to trim the same but of no use.

If I type the content ALPHAGEO, then i get the results but otherwise

only errors.

I tried to press F2 and see the contents if there is leading or

trailing spaces but no.

I tried to compare the same with the IF function, it is says both are

different and IF formula result is false.

Is there is a way to find out what is the difference by any formula or

VBA?

Regards,

Madiya