Insert Lines
in [Functions]
|
Prev: Formula to calculate Latest Cost (inventory valuation)
Next: Dynamic pivot table linked to dynamic excel spreadsheets
From: RENEE on 29 Apr 2010 16:29 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.
From: alanglloyd on 29 Apr 2010 17:01 On Apr 29, 9:29�pm, RENEE <RE...(a)discussions.microsoft.com> 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
From: Dave Peterson on 29 Apr 2010 18:16 Check your other post. 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. -- Dave Peterson
From: RENEE on 4 May 2010 16:35 Sorry - I lost you at "replace one new para with 4 new paras". I copied some of the lines into Word, but couldn't figure out what you mean by the foregoing. Then, save as .txt file and change the extension from txt to csv? Then copy to Excel? Or, is it possible to open a word file as an excel file? Thank you. "alanglloyd(a)aol.com" wrote: > On Apr 29, 9:29�pm, RENEE <RE...(a)discussions.microsoft.com> 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 > . >
From: Billns on 5 May 2010 14:42
On 4/29/2010 1: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. Record a macro to insert four lines and move down one line, then repeat it as needed. Bill |