Hello,
I have a massive excel files (2 sheets, 700.000 lines earch, in 10 columns). My sheets are called 'sheet1' and 'sheet2'
I need to replace some words in the columns by numbers, to create variables that i can analyze.
The columns on the which are work are, for instance, this one:
HTML Code:
I have this macro, i think i can adapt it, but there are two problems:
1) this macro replaces in all the file, not in the columns, and "1" in column 4 does not mean "1" in column "4" (it's not the same word that is replaced)
2) I'm afraid this won't work on a big file, it's not optimized at all.
HTML Code:
I give you a file of the words i need to replace and of the columns, so you see a bit how painful it can be.
Bookmarks