O
Odin
Hi All,
I have asked here before and on other fora for help on the following
problem ( i am a total novice at VB and Macros):
I have a large excel spreadsheet with alpha-numeric data. I want to be
able to compare two cells in the same row and return the disimilar
characters in another cell(s).
e.g. I have in cell B2, "BB26" and in cell C2, "BBZ5". I need to
compare the cell C2 to cell B2 and return the disimilar characters in
cell D2 which in this case would be the characters "Z5".
If possible i would like to specify in cell E2 the positions of the
differing characters i.e. cell E2, "34" representing the 3rd and 4th
positions of the disimilar characters.
If there is a better and more elegant solution to this problem that
would provide a similar solution, i would appreciate your help very
much.
Thank you in advance.
I have asked here before and on other fora for help on the following
problem ( i am a total novice at VB and Macros):
I have a large excel spreadsheet with alpha-numeric data. I want to be
able to compare two cells in the same row and return the disimilar
characters in another cell(s).
e.g. I have in cell B2, "BB26" and in cell C2, "BBZ5". I need to
compare the cell C2 to cell B2 and return the disimilar characters in
cell D2 which in this case would be the characters "Z5".
If possible i would like to specify in cell E2 the positions of the
differing characters i.e. cell E2, "34" representing the 3rd and 4th
positions of the disimilar characters.
If there is a better and more elegant solution to this problem that
would provide a similar solution, i would appreciate your help very
much.
Thank you in advance.