Forum Discussion
Automatically replace names with numbers
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...
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.