To match a column with original names

  • Hi I have two columns. A column has employee names which has a data validation. But even with data validation employees are entering either only first name or sometimes first name with initials. B column has names which are recorded from records. I need a formula to replace the names in A column automatically. Please help

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!