steelstorm
02-07-2013, 01:28 PM
Hello,
I currently receive a spreadsheet that has the majority of the address listed in a single cell. I am having issues wrapping my head around how I can have this broke into multiple cells like my format needed below.
I realize this would have to be able to recognize different types of roads like st, alley, drive....but I have not been fortunate enough to find any type of examples like this online for any help.
How the data is received:
722 SAINT OUEN ST
How I need the address broke down:
Street NO: Name: Type:
722 Saint Ouen St
Any help or feedback is greatly appreciated, this one is definitely out of my league.
I currently receive a spreadsheet that has the majority of the address listed in a single cell. I am having issues wrapping my head around how I can have this broke into multiple cells like my format needed below.
I realize this would have to be able to recognize different types of roads like st, alley, drive....but I have not been fortunate enough to find any type of examples like this online for any help.
How the data is received:
722 SAINT OUEN ST
How I need the address broke down:
Street NO: Name: Type:
722 Saint Ouen St
Any help or feedback is greatly appreciated, this one is definitely out of my league.