• 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.

Search results

  1. H

    Extract some data from a cell to another

    I am using excel for mac 2011.. it shows #VALUE!.. but your online link is showing the proper result.. does version makes a difference?
  2. H

    Extract some data from a cell to another

    Hi Shrivallabha, Thanks, I tried the formula with the address in A1 but unfortunately its not working. I do not know Excel Much so I cant read formula as well, thus I wouldn't know if its tricky.. the result shows #VALUE!
  3. H

    Extract some data from a cell to another

    Hello Bobhc... Thanks but it still a tedious process. Formula would work best since the address column keeps adding up everyday. If I have a formula I can copy down to the other colum and it would just extract automatically. In my previous someone helped me with a formula to extract pincode...
  4. H

    Extract some data from a cell to another

    Hello there.. I have few hundred cells contains postal address in each cell eg: Cell A1 Fahim Shah B1 909 Sobha Aquamarine Sarjapur Outer Ring Road Bangalore - 560103 KA CellA2 Annu Singh 206 207,Covalense Technologies, Aaditya Trade Center, Ameerpet Hyderabad - 500038 AP I...
  5. H

    Extract pincode from address

    oh sure. Thanks a lot Hui :)
  6. H

    Extract pincode from address

    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
Back
Top