Forum Discussion
MTucker
Jul 23, 2019Copper Contributor
Delimiting Excel Addresses
I have a list of 19,000+ addresses all in one cell. I need the information delimited into the following columns: Address line 1, Address Line 2, City, State, Zip Code. Unfortunately, the format of th...
Twifoo
Jul 23, 2019Silver Contributor
It seems you may initially employ Text to Columns with space as delimiter, whereafter you decipher your next action.