View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
A.J. A.J. is offline
external usenet poster
 
Posts: 1
Default Critical - Converting Single Column Address Data into Multiple Col

I have a list of addresses in the following order:

names (a1), business names (a2), streets (a3), city state and zip codes
(a4), business phone (a5), cell phone (a6), and two blank lines below each
address listing.

I need to convert each cell of data into columns so I can create a mail merge.

Help is greatly appreciated