As example with the first address when I combine I get 6363 W AIRPORT BLVD
Notice the BLVD being separated by large space. I tried the Trim but did nothing.
There are other issues also, like Apt # being in address and other things, but right now, just trying to get the first step done is not working.
Is it something like this?
Formula:
Please Login or Register to view this content.
v A B C D E 1 StreetNum StreetName SType STDIrection 2 6363 AIRPORT BLVD W 6363 W AIRPORT BLVD 3 6689 SAM HOUSTON PKWY W 6689 W SAM HOUSTON PKWY 4 11801 MONTGOMERY RD W 11801 W MONTGOMERY RD 5 8104 TIDWELL RD W 8104 W TIDWELL RD 6 6201 BELLFORT ST W 6201 W BELLFORT ST 7 10633 AIRPORT BLVD W 10633 W AIRPORT BLVD 8 103 WILBURN AVE W 103 W WILBURN AVE 9 4616 HOWARD RD W 4616 W HOWARD RD 10 7715 HARDY RD W 7715 W HARDY RD 11 207 PHILLIPS 2ND FLOOR W 207 W PHILLIPS 2ND FLOOR
Last edited by AlKey; 08-03-2017 at 10:08 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you. Yes it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks