Thanks a lot for all the responses
@snb, I tried your technique but it threw an error "Argument Not Optional" highlighting "Space".
@Marcol, Then I tried your technique and it worked for one cell. So I modified it a little so it loops through length of column A:
This above returns something like this:
But rather than this:
My intention was to pull the name with the longer length when comparing all of Column A and B (so it wouldn't just be comparing B1 and A1 but perhaps B3 and A2) like this:
It may be a minor change that fixes this, but I don't fully understand your code.
Thanks for response.
Bookmarks