E
Eric
I have been provided with a few thousand mailing addresses. Each address is
written into a single cell, i.e. 123 Fair St. Orlando FL 12345, instead of
123 Fair St. / Orlando / FL / 12345.
I need to break out the addresses into separate columns by Street / City /
State / Zip.
I am familiar with the text to columns function, but the addresses are not
consistent enough to make this straight forward.
Any help is greatly appreciated.
Thank You,
written into a single cell, i.e. 123 Fair St. Orlando FL 12345, instead of
123 Fair St. / Orlando / FL / 12345.
I need to break out the addresses into separate columns by Street / City /
State / Zip.
I am familiar with the text to columns function, but the addresses are not
consistent enough to make this straight forward.
Any help is greatly appreciated.
Thank You,