Hi folks, I've been busting my brain on this one for a little while now. Lets say I have two strings, 12341234123 and 1234.123.4123, assigned to two variables, Nums1 and Nums2 respectively. As you can see, the only difference between the strings is the periods in the second string.
I tried using the Like operator to see if I can match them, with no luck:
I tried formatting Nums1, since I had tested formatting and saw it doesn't just format a cell, it formats the string itself:
I tried using format on both variables, I tried using = instead of Like, and I even tried making a new variable where I forced Nums1 into Nums2's format using LEFT, RIGHT, and concatenations with the periods. All with no luck. I'm out of ideas, can anyone give me a hand?
Bookmarks