I have a situation where I have account numbers that contain letters. I need to change the letters to numbers creating an int value. I have several thousand account numbers to change and several different letters to convert.
I would like to convert an "A" to 1, "B" to 2, "C" to 3, etc.
Any ideas as to how to accomplish this easily?
Thanks,
Ron--
I would like to convert an "A" to 1, "B" to 2, "C" to 3, etc.
Any ideas as to how to accomplish this easily?
Thanks,
Ron--