A few addresses in data base have numbers after them. Need to eliminate. Examples in attached file. However, sometimes address like S Hwy 6, is correct.
Thanks
A few addresses in data base have numbers after them. Need to eliminate. Examples in attached file. However, sometimes address like S Hwy 6, is correct.
Thanks
pick44 I had to do this in two steps.
First I assumed the expected value in B4 is a typo.
Formula in C2 and filled down isFormula:Please Login or Register to view this content.
In D2 and filled down.Formula:Please Login or Register to view this content.
A B C D 1 NOW SHOULD BE Step 1 Step 2 2 8162 RICHMOND AVE 1809 AVE 8162 RICHMOND AVE 8162 RICHMOND AVE 8162 RICHMOND AVE 3 3100 S WEST SAM HOUSTON PKWY 231 PKY 3100 S WEST SAM HOUSTON PKWY 3100 S WEST SAM HOUSTON PKWY 3100 S WEST SAM HOUSTON PKWY 4 2410 S KIRKWOOD DR S 128 DR 2410 S KIRKWOOD DR S 128 DR 2410 S KIRKWOOD DR S 2410 S KIRKWOOD DR 5 2601 S BRAESWOOD BLVD S 301 BLVD 2601 S BRAESWOOD BLVD 2601 S BRAESWOOD BLVD S 2601 S BRAESWOOD BLVD 6 5500 SAMPSON 2308 5500 SAMPSON 5500 SAMPSON 5500 SAMPSON 7 131 ALDINE BENDER RD 1111 131 ALDINE BENDER RD 131 ALDINE BENDER RD 131 ALDINE BENDER RD 8 2600 S HWY 6 This one is correct as shown in a8 2600 S HWY 2600 S HWY 6
Last edited by FlameRetired; 08-22-2017 at 06:31 PM. Reason: fine tune last formula
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks