I am using Excel 2010 and cleaning up some data and I have two cells that appear the same but when I compare ActiveCell to ActiveCell.Offset(1,0) they do not match.
When I broke it down I found the mid string that did not match and I got its value using
SndChr = Asc(Mid(ActiveCell.Offset(1...