Excel formula help

[Gopal_Gope]

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 

[#2]

@Gopal_Gope 

If you want us to help you. please provide detailed and specific information.

[#3]

@HansVogelaar 

• *The Demo Data you may download the file from here 
• https://1drv.ms/x/s!Al_W0BkwmMJVig2b5VFNMiibdhNc

[#4]

@Gopal_Gope 

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.

[#5]

@HansVogelaar 

So what changes do I have to make to understand this?

Whatever data we have is of this type.

[#6]

@Gopal_Gope 

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)

[#7]

@Gopal_Gope 

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.

[#8]

@SergeiBaklan 

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.

[#9]

@Gopal_Gope 

Link was returned by Google. You may google for other sources if this one doesn't work for you.