Hello everyone, this is my first time posting on such a forum so excuse my use of incorrect terminology if I’m using any.
I’m having an issue with codifying comma separated values in a large data set. As I demonstrate in the attached workbook I want to convert values in a cell to their relevant code e.g ‘bath, water, cow’ --> ‘X002, X009, X004’ but my current method is laborious and unsuited to the large 2000+ cell columns of data I have to convert.
The slow method that I currently use goes as follows: Edit --> Find --> Replace… --> Find what : ‘X’ ; Replace with : ‘Y’ --> REPEAT . However this is taking 10s of hours.
Can anybody resolve this problem?
Thanks for any advice, the kindness of strangers on the internet is always something to behold!
Bookmarks