Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Finding duplicates between two columns with partial text [Closed]

Report
Posts
1
Registration date
Friday April 19, 2019
Status
Member
Last seen
April 19, 2019
 -
Hello,

I am trying to compare a list of names in column A to a list of names in column B. I am trying to highlight the names in column A that match the list in column B however, the naming format is not the same. Column A has the entire last name and first name but cuts off the first name if there is more than 15 characters in the box (including a space). The names in column B is formatted by last name first name middle.

Thank you
See more