View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] GARYJG2@HOTMAIL.COM is offline
external usenet poster
 
Posts: 3
Default HOW TO MAKE A MAILING LIST IN ONE COLUMN HAVE CONSISTANT ROWS

I have a mailing list that is all in one column. I know how to separate
each line of information into a separate column if each person has the
same amout of rows. My problem is some of the name have 5 rows of
information and some have 6 - is there a way to make the row consistan
so I can use then use the offset to separate into different columns