View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scott
 
Posts: n/a
Default How do I separate address information from within an Excel cell?

I have a Christmas Card list that was created using a single cell for the
whole address. Street, City, Zip/Postal etc. I need to split those
components out into separate cells in order to do a proper mail merge. Is
there any way to do this. I am not completely unfamiliar with macros but I
if that is the solution I would require a fair bit of hand holding.

Thanks

S.