Hi,
I am trying to create a code based on text using excel functions. I have a long list of names that I want to change to something meaningless. The names appear more than once in the list but I want it to return the same answer for each occurrence. I'd also like the length of the code to match the length of name:
Fred Blegs = XDAF GKAZT
Jon Smith = NIC TSQWP
Is this possible? If so how? Should I think about VBA?
Any suggestions would be much appreciated.
Bookmarks