M
MikeSD
I have two cells that, to the naked eye, look the same. They are both
formatted as "text". The contents come from two different data sources (one
a spreadsheet and the other a database). When compared with a simple formula
to validate their sameness, (ie. if(a2=b2,"match", not a match") ), the
result is "not a match".
I've tried to force the format by multiplying both cells by 1 in a cut/paste
special effort and then changing them back to Text from General but they
still don't match, to Excel.
It appears that there is some Hidden formatting going on but I can't find
it. Any ideas?
Thanks.
formatted as "text". The contents come from two different data sources (one
a spreadsheet and the other a database). When compared with a simple formula
to validate their sameness, (ie. if(a2=b2,"match", not a match") ), the
result is "not a match".
I've tried to force the format by multiplying both cells by 1 in a cut/paste
special effort and then changing them back to Text from General but they
still don't match, to Excel.
It appears that there is some Hidden formatting going on but I can't find
it. Any ideas?
Thanks.