Can I use excel to look up a list of names (text) and identify the matches? An additional issue complicates this, so question 2 is: can I have Excel identify a match say if a certain # of characters match, but not all match exactly?
For example: I see: AJReynolds and A J Reynolds and A.J. Reynolds, and they all need to be identified as a match........
Thanks in advance!!
For example: I see: AJReynolds and A J Reynolds and A.J. Reynolds, and they all need to be identified as a match........
Thanks in advance!!