grasshappa
New Member
- Joined
- Sep 5, 2006
- Messages
- 6
It seems to me that what I'm trying to do is quite easy, but I haven't been able to figure it out. I have two lists in two columns - one is a list of six digit numbers - the other is a list of ascending seven digit numbers. For each six digit number, there is one and only one seven digit number which begins with those six digits, but the seventh digit is random. I want to replace all of the six digit numbers with their corresponding seven digit numbers. I can't figure out which combination of lookup or if or match or replace commands to use...
009988 0000014
000823 0000027
234534 0000031
more many more
Please help! Thank you very much in advance!
009988 0000014
000823 0000027
234534 0000031
more many more
Please help! Thank you very much in advance!