How do you index/codify comma separated values in large data sets?

[QuantStutter]

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 indexing/codifying comma separated values in a large data set. As I demonstrate in the image 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!

[Pete_UK]

You shouldn't have started a new thread, as the forum frowns on duplicate threads - it is better to continue in your first thread and leave this one alone.

Pete