Forum Discussion
Separating an address in one column to columns: address1, address2, city, state
I need to separate a column listing addresses into 4 columns, address1, address2, city, state. Text to column does not separate because there is not any comma's only spaces and I cannot separate by s...
There must be some delimiter for each part of the address; otherwise, no logic would explain how the address would be separated into parts.