Forum Discussion
Gopal_Gope
Nov 28, 2023Copper Contributor
Excel formula help
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
HansVogelaar
Nov 28, 2023MVP
If you want us to help you. please provide detailed and specific information.
- Gopal_GopeDec 08, 2023Copper Contributor
- *The Demo Data you may download the file from here
- https://1drv.ms/x/s!Al_W0BkwmMJVig2b5VFNMiibdhNc
- HansVogelaarDec 08, 2023MVP
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.
- Gopal_GopeDec 09, 2023Copper Contributor
So what changes do I have to make to understand this?
Whatever data we have is of this type.