M
Mike
I have address information obtained from a 3rd party. All information for a
particular adress is contained in a single cell with no delimiters between
address1 address 2 suburb state and postal code. I can't use fixed width in
text to columns as all components of the address are different character
lengths.
Anyone got any suggestions?
particular adress is contained in a single cell with no delimiters between
address1 address 2 suburb state and postal code. I can't use fixed width in
text to columns as all components of the address are different character
lengths.
Anyone got any suggestions?