Just a little more clarification. Their are over 5000 entries in each of
the two columns. Below is the same samples with underscores to show where
one column ends and the other begins. I would be more than happy to send the
whole excel file if that would help. It's size is: 825 KB (845,312 bytes)
1559-F-1 PT SW_______ 65-4-120-053-0510
1559-F-2 PT SW_______ 65-4-120-053-0520
1560-F-1 E 1/2________ 65-4-120-054-0101
1560-F-1 PT SE_______ 65-4-120-054-0120
1560-F-1 PT SE_______ 65-4-120-054-0130
1560-F-2-A LOT_______ 65-4-120-054-0200
1560-F-2-B LOT ______65-4-120-054-0210
1560-F-3 PT SE_______ 65-4-120-054-0220
1560-F PT SE 1/_______ 65-4-120-054-0230
1562-F PT SE 1/_______ 65-4-120-054-0410
Thanks again to anyone who offers a solution.
"Mike" wrote in message
...
Sorry, I had them separated but when I posted they ran together for some
reason.
The correct second column of numbers would be in the below sequence with
13 numbers.
65-4-120-053-0510
The first column would be the preceding numbers in front such as 1559-F-1
PT SW. These could very in length but the 2nd column is consistant with
the 13 numbers and dashes.
"Biff" wrote in message
...
Hi!
Where does one number end and the other begin?
1559-F-1 PT SW 65-4-120-053-0510
the old parcel number of the first row as "1559-F-1"
the new parcel number of "65-4-120-053-0510"
Where is "PT SW" ? Is it part of the old style number? Part of the new
style number?
Biff
"Mike" wrote in message
...
Hi
Hope someone can help. I have two sets of numbers that I would like to
cross reference with each other. They are parcel numbers. The first
column is the old style. The second column holds the new style. I would
like to create a form that if you input one or the other of the values
it's counter part would show up. An example below:
1559-F-1 PT SW 65-4-120-053-0510
1559-F-2 PT SW 65-4-120-053-0520
1560-F-1 E 1/2 65-4-120-054-0101
1560-F-1 PT SE 65-4-120-054-0120
1560-F-1 PT SE 65-4-120-054-0130
1560-F-2-A LOT 65-4-120-054-0200
1560-F-2-B LOT 65-4-120-054-0210
1560-F-3 PT SE 65-4-120-054-0220
1560-F PT SE 1/ 65-4-120-054-0230
1562-F PT SE 1/ 65-4-120-054-0410
Say if I entered the old parcel number of the first row as "1559-F-1" I
would like it's equivalent "65-4-120-053-0510" to show up. Or switch it
around and type in the new parcel number of "65-4-120-053-0510" and the
old number of "1559-F-1" should appear.
There are also three basic numbers that I will be using.
65-4-120-XXX-XXXX
66-4-120-XXX-XXXX
67-4-120-XXX-XXXX
Is there a way to just type in the "X" values and not have to use the
whole number or even need to type the dashes but yet still have then
show up.
I have never used this site before and I may be asking for way to much.
If so please just ignore my request. I thought this would or should be
fairly simple and volunteered to do it, but now find myself scratching
my head after several hours at the attempt.
Thanks in advance for any help.
Mike
|