View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ratatat Ratatat is offline
external usenet poster
 
Posts: 7
Default Address blocks to columns

I have an excel file that contains 500+ address blocks because it was
originally a pdf file that I converted to excel format. My ultimate goal is
to do a mail merge from this file but that's not possible in the format it is
currently. Is there a way to pull the information from that sheet so that it
is organized into columns? Once it's there I can do text to columns to
separate items when necessary but I don't know how to get there.