View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Callum
 
Posts: n/a
Default how do I insert 4 rows in between each value in a list of data

I have a long list of data in a notebook.txt file.

I want to copy and paste it into excel, but leaving 4 empty rows in between
each value. i.e. a list of 10 values will now be 50 rows long (but with 40
spaces).

Can anyone help?

Thanks in advance