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...