• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract pincode from address

S

sdsurzh

Member
Hi,


I want to extract pincode from the below address.


AVENIDA TECNOLÓGICO S/N ENTRE TECNOLÓGICO Y URBANISTAS COL. SAN LUIS C. P. 20190 AGUASCALIENTES, AGS. TERRENO


Thanks in advance,

Suresh Kumar S
 
Thanks Kaushik,


I have already gone through the thread.

But for the below case it is not working


AVENIDA TECNOLÓGICO S/N 15 ENTRE TECNOLÓGICO Y URBANISTAS COL. SAN LUIS C. P. 20190 AGUASCALIENTES, AGS. TERRENO.


Since the 15 street # is coming it shows #value.


Help me,


Thanks,

Suresh Kumar S
 
Hi Suresh,


I believe 20190 is your PIN code and this will always be in 5 digit format.


Can you plz clarify if the PIN code is always followed by P. or P. is a part of "SAN LUIS C. P."


If P. is not a part of "SAN LUIS C. P." then follwing should work:


=MID(A1,SEARCH("P.",A1)+3,5)....[A1 is your text]


Looking forward to your clarification.


Kaushik
 
Hi there.. How can i extract 6 digit pin-code from address like this in a cell? Could you help? Thanks


Neelam Kapoor

Bakers Circle (I) Pvt Ltd

# 3, Taimoor Nagar, 2nd Floor (Opposite New Friends Colony Gurudwara)

New Delhi - 110065

Delhi
 
Hatim


Firstly, Welcome to the Chandoo.org Forums


Can I please direct you to the 4 Sticky Green Posts at http://chandoo.org/forums/

In here you will see the rules state, "Please start a new post for a new question"


Starting a new post ensures that your post will be seen and your question will be answered faster. It also makes searches much more relevant & easier


You may want to try a formula like:

=MID(A1,FIND("- ",A1)+2,6)
 
You must log in or register to reply here.
Back
Top