I have attached what seems to me to be a trivial problem (that I can't solve). Row and row 2 should be identical, but the 'Right' function in D1 seems to return a different value vs. D2. What is the difference between A1 and A2. BTW, I have tried to format the A column as text, but that doesn't help.
Thanks.
dave
ps. Well duh - lots of spaces at the end. Sorry about that.
Bookmarks