LinkBack URL
About LinkBacks
Hi excel guys
The file attached contained addresses in column c and I need to have a column for address, city, state, zip
Hi excel guys
The file attached contained addresses in column c and I need to have a column for address, city, state, zip
based on your specific examples I believe the below *almost* works (i.e. Villages versus The Villages):
Formula:
Please Login or Register to view this content.
In reality these things are generally much more complex where there is no clear delimiter between each component and/or the addresses are inconsistent in terms of which elements they contain.
Last edited by XLent; 03-02-2019 at 03:42 AM. Reason: modified City
Hi King
Show your desire output in Column D,E,F (City, State, Zip.)
I Don't understand which one is pick for state or city and also Pincode (Might be Last one)
Regards,
MohanS
"Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi
You can simply say thanks by clicking "*Add Reputation" icon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks