Nov 28 2023 11:10 AM
Hi,
We need help please help us as soon as possible
I need a formula that can find the district from the address list and output it to another column?
Microsoft Excel 2007 version
Nov 28 2023 11:30 AM
If you want us to help you. please provide detailed and specific information.
Dec 08 2023 08:23 AM
Dec 08 2023 08:41 AM
The data appear to have different layouts - some have commas and others don't. And the district name may consist of one word or of multiple words. So I do not see how we could extract the district from these data.
Dec 09 2023 09:02 AM
So what changes do I have to make to understand this?
Whatever data we have is of this type.
Dec 09 2023 09:15 AM
Do you have a comprehensive list of the names of all districts in all states? That might help (but probably still not solve the problem completely)
Dec 09 2023 10:56 AM
You may download list of pincodes from here All India Pincode Directory | Open Government Data (OGD) Platform India or any other resource which provides such information, add info into another sheet of your workbook and lookup district based on pincode from that sheet.
I don't think that pincodes are updated frequently.
Dec 11 2023 09:50 AM
I have no idea how to download the file by going to this link. Share with us the direct link of the file on which we can click and download the file.
Dec 11 2023 10:00 AM
Link was returned by Google. You may google for other sources if this one doesn't work for you.