I use =IF command to determine Trus False agguments, but.......

  • Thread starter Thread starter gcorrigan
  • Start date Start date
G

gcorrigan

Hi,

I use =IF command to determine Trus / False agguments.

For instance if someone sends me a list of names I would put them in
coloumn A. I then put my names in Coloumn B.

If I create a =IF in coloumn C it will determine if the names in Colum
A are the same and return False if they are not the same.

OK so far.

This command only returns the TRUE value when the format of the words
are identical (not case sensitive) but often as names in a coloumn are
pasted from other application they have "unseen" formats such as
spaces after the last word in the name. In this case, the programs
sees it as false as quite rightly they are not identical.

I have tried to remove formats, but that doesnt help.

Is there a way of formatting the text such that Excel sees the two
coloums of texts as the same format so the aruements will return True
or False.

many thanks in advance

Glenn
 
Glenn,

The TRIM function, which removes spaces except those between words, should
resolve this issue.

It may be easiest to insert the formulas in a helper column and then
copy/paste special/value to remove the formulas. Once that is done you can
delete the original column.

PC
 
Back
Top