Hello everyone,
I would like to start saying that I am very new in Excel : of course I have been using it a lot for classical stuff, using some basic functions, but that's it. It seems to me after having read a few topics here that Excel is a powerful tool with functions I would never thought I could find in it.
As I am about to start a new project, I would first ask if Excel is gonna be powerful enough to do this (if not, I should consider finding another software for this matter).
Here is my idea : I would like to have in my excel file an input column called "address" where a user would write a full address. In another part, I would like to have a few more columns with more detailed information (street, house number, city, zip code, etc.), which would be my outputs.
As the user would fill in the input by typing an address, I would like to create a method which would identify some terms of this input and fill up the output accordingly.
Example : you type "140 Commonwealth Ave, Chestnut Hill, MA 02467, United States", it would automatically put "140" in the street number, "Commonwealth Avenue" in the Street Name, "Massachusetts" in the state, etc.
Eventually, I am considering to add a database communication to offer some suggestions in output columns if some informations are missing in the full address. Let's say that the user forget to mention the name of the building in the full address but there is a name for the street : the database could provide some content that Excel would help to display (with a spinner containing all the buildings in the street for example).
So here is my two simple questions :
1/ Is Excel a relevant choice for this project ?
2/ If yes, could you have the kindness of mentioning some "methods" or "tools" that Excel provides and that I should study in order to get further ? I really don't know a lot about Excel and some suggestions might help me to focus on the important matter for my project!
Thanks a lot for your time.
I would like to start saying that I am very new in Excel : of course I have been using it a lot for classical stuff, using some basic functions, but that's it. It seems to me after having read a few topics here that Excel is a powerful tool with functions I would never thought I could find in it.
As I am about to start a new project, I would first ask if Excel is gonna be powerful enough to do this (if not, I should consider finding another software for this matter).
Here is my idea : I would like to have in my excel file an input column called "address" where a user would write a full address. In another part, I would like to have a few more columns with more detailed information (street, house number, city, zip code, etc.), which would be my outputs.
As the user would fill in the input by typing an address, I would like to create a method which would identify some terms of this input and fill up the output accordingly.
Example : you type "140 Commonwealth Ave, Chestnut Hill, MA 02467, United States", it would automatically put "140" in the street number, "Commonwealth Avenue" in the Street Name, "Massachusetts" in the state, etc.
Eventually, I am considering to add a database communication to offer some suggestions in output columns if some informations are missing in the full address. Let's say that the user forget to mention the name of the building in the full address but there is a name for the street : the database could provide some content that Excel would help to display (with a spinner containing all the buildings in the street for example).
So here is my two simple questions :
1/ Is Excel a relevant choice for this project ?
2/ If yes, could you have the kindness of mentioning some "methods" or "tools" that Excel provides and that I should study in order to get further ? I really don't know a lot about Excel and some suggestions might help me to focus on the important matter for my project!
Thanks a lot for your time.