View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Extract Mailing Address to multiple cells

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,