View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ben Ben is offline
external usenet poster
 
Posts: 509
Default How to split columns with multiple lines w/in cells

I have complete addresses in each cell. For example, cell A1 has:

John Smith
123 Main St
Anytown, XX 12345

All lines of data are contained within a single cell. How can I split it so
I have the first line (John Smith) copied to cell B1, line 2 to C1, and line
3 to D1? I am trying to avoid the manual copy/paste method.

Thanks for any advice!