View Single Post
  #1   Report Post  
Big-D
 
Posts: n/a
Default Transposing addresses

I have a s/sheet with 1,000 addresses, all in column A, most over 4 lines,
some over 5.

Is there an 'easy' way of converting each of these address blocks into a
single row, with each line in it's own column?

(I ultimately need to use these addresses in a Word mailmerge).

Thanks for any help ... !