In support of this post:
https://excelfox.com/forum/showthrea...pplied-over-it

_____ Workbook: address sheet.xlsm ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
1
 Address Door# Direction street name roadtype street name + roadtype City Name
2
204 6 AVE NW
204
6
 AVE NW
3
2510 5 AVE N
2510
5
 AVE N
4
1 CICADA RD
1
 CICADA RD
5
100 annacis Pkwy
100
 annacis Pkwy
6
100 MAIN ST
100
 MAIN ST
7
10008 107 ST
10008
107
 ST
8
1001 110 AVE
1001
110
 AVE
9
10010 102A AVE NW
10010
 102A AVE NW
10
10115 110 AVE
10115
110
 AVE
11
102 11 AVE S
102
 S
11
 AVE
12
10205 134 AVE NW
10205
 134 AVE NW
13
10235 101 ST NW
10235
 101 ST NW
14
10365 97 ST NW
10365
 97 ST NW
15
105 MARTIN ST
105
 MARTIN ST
16
10504 100 AVE
10504
100
 AVE
17
10600 100 ST
10600
100
 ST
Worksheet: Sheet1