How can I automate bulk renaming of cells in execel?

Question

Command line

There is an excel table with data where the category field contains the names (word) and it is necessary that there be a category id (number).
There are more than 14,000 records in the table
Manually for a very long time.
Since there are many categories and they are different,
I would like to automate this somehow.
So that the id of the corresponding category is taken automatically from a file or from somewhere else and replaces the name of the category.
Or, as an option, there may be a script for the command line.
Unload the category column into a txt file, process it and then insert it back into the table.
I hope I have explained...

Answer 1

All three options that you described are possible.
1- can be formulas. You need a list of matches. See VLOOKUP function.
2- possible macro. You have to write code.
3- you can use external scripts. There are many options here. Depends on your software.