Automatically replace names with numbers

Occasional Visitor

I have a column that is full of about 75 different names.  I need to replace those names with their work ID numbers.  Is there a way that this can be done without doing a replace function for each of the 75 names?

2 Replies

My first thought is to create a new blank column and use vlookup to find the ID numbers for each person -- and then to copy the values in the new column and paste over the names as values only. I do something similar to this frequently when I need to present data that contains student names.



Did you get solution for this, I am trying to anoymise data which is e.g a name with an ID, each name knows their ID number that is assigned to them, did you get a solution in the end 


best regards