replacing large amount of cells

[Lmadahali]

Hello everyone.
I have a dataset which is a coauthorship network.Its data is like this:

1992,M_DINE,R_LEIGH,P_HUET,A_LINDE,D_LINDE
1992,C_BURGESS,J_CLINE,M_LUTY
1992,M_DINE,R_LEIGH,P_HUET,A_LINDE,D_LINDE
1992,F_ZWIRNER
1992,O_HERNANDEZ
...
It has about 38000 rows. I want to replace names of the authors with unique numbers so to do this I copied the names of the authors to another excel file, and now I want to replace the authors names(in the first file) with its row number in the second file. What should I do?Should I write a macro ?
It doesnot matter whether they are in one file or 2 seperate file.

[daffodil11]

I'd go the VB route. It's very fast.

To use this, go to Excel, hit Alt+F11, Insert, Module, and paste the code below in.

Change the range in the first part to match the sheet name and column of where your table and numbers is.

Change the sheet name and Column for where the stuff you want to change is.

Please Login or Register  to view this content.