Compare two cells from reference cells

M

Mike K

Oh wise ones,
I have two cells that I am comparing. The values come from an array
function that is pulled from a sql server, so the reference cells are not
very editable. Lets call them A1 and A2. I refer to them in B1 and B2 where I
compare them for equality. They look identical, but they do not compare as
true so there must be some leading/trailing spaces. How can I take out the
spaces from B1 and B2 so they compare properly?

Thanks,
Mike
 
B

bpeltzer

TRIM will removing leading and trailing spaces. Another common cause of
failure to match is a difference between a number (123) and a string
representation of that number ("123"). TRIM will also convert the number to
its equivalent string; VALUE will convert a string of digits to its numeric
equivalent.
 
M

Mike K

Thanks, that works beautifully. I forgot about the TRIM function. I've never
had to use it before, but I knew there was something like that to suit my
purpose. They sometimes tinker with the PLC tags, and what was working one
day, may not be the next. Then it's up to me to fix my app- again.

Thanks again,
Mike
 
Top