Thread: Insert Lines
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] alanglloyd@aol.com is offline
external usenet poster
 
Posts: 38
Default Insert Lines

On Apr 29, 9:29�pm, RENEE wrote:
I have a worksheet sent to me with over 700 names on it. �I need to put 4
extra lines under each name. �Is there a way to do this without having to
individually insert those lines as this will take a long time. �Thanks.


Output as CSV
Open in word processor
replace one new para with 4 new paras
save as .txt file
change extension to csv
open in XL & save as a worksheet.

Alan Lloyd