[SIZE=12px]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 original full names .I need a formula/macro to replace the names in A column automatically. Please help[/SIZE]
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!