VBA required to delimit cells with some rules applied on it
Hi Friends,
I have task to delimit the addresses provided in CellS A:A, i have split in the format of
st number(B Cell),Direction(C Cell),st name(D Cell) & st type(E Cell),
Here i having complexity in Directions(N,E,S,W)... where it comes next to st number sometimes & at the end of the address sometime,
also sometime attached with st number itself, i m manually cutting & pasting it in C cell,
for better understanding i have attached my working sheet, could someone help me complete this task,
i have thousands of address to convert it.
Hi Marc L, Attachment 678028
Your script worked perfectly for 90% of addresses,
i need your help here, actually i run the script in some hundreds of addresses, i found some
issues while running script on different scenario of addresses.
i have highlighted those issues in the aatched image.
i tried to edit the script, but not happening for me.
i understand that confusion happened due to the seperation of streetname & roadtype, so if possible can you please combine streetname & roadtype as a single cell..
so finally we it will be like (New_address sheet.xlsm)
A Cell : Addresses
B cell : Door#
C cell : Direction
D cell : StreetName+Roadtype
Could you please help me to resolve this, as it will be ery helpfull for me.
Thanks in Advance.
Last edited by amb2301; 05-16-2020 at 06:27 PM.
Reason: update
Bookmarks