Originally I was going to ask whether the OP had numbers or text. But Marcia offered a solution using the RIGHT function, and the OP replied "No, but LEFT works; thanks". So I decided if LEFT worked, it must be a string value, not text.
Macropod, are you saying MOD will work with string values, too (as long as the string represents a number)? I didn't realize that.
|