Forum Discussion

UchtmanD's avatar
UchtmanD
Copper Contributor
Dec 03, 2018

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 the 75 names?

Formulas and Functions

2 Replies

Sort By
  • evonne_mc's avatar
    evonne_mc
    Copper Contributor
    Mar 12, 2022

    UchtmanD 

     

    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 

    evonne 

  • jimfikes's avatar
    jimfikes
    Copper Contributor
    Dec 03, 2018

    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.

Resources