software

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


U¿ytkownik quot;Callumquot; gt; napisa³ w wiadomo¶ci
...
gt; I have a long list of data in a notebook.txt file.
gt;
gt; I want to copy and paste it into excel, but leaving 4 empty rows in
between
gt; each value. i.e. a list of 10 values will now be 50 rows long (but with
40
gt; spaces).
gt;
gt; Can anyone help?
gt;
gt; Thanks in advance

one way would to write macro but another is to input in additional column
series of numbers ( starting 1 step 4 )
then in next for columns create missing number 2,3,4,5, 6... etc using
simple formula b2 1 then copy all numbers in one column and sort ascending
mcg

Hi Callum,

No answer so I'll have a go.

Answer depends on how long the list is.

If not too long, then select Insert-Rows. Then press the F4 key to
repeat the task as necessary.

To automate it a bit more here's a macro which you can attach to a
shortcut key combination. (Gives one keystroke row each 4 row
insertion)

Sub Insert4Rows()
ActiveCell.Range(quot;A1:A4quot;).Select
Selection.EntireRow.Insert
ActiveCell.Offset(5, 0).Range(quot;A1quot;).Select
End Sub

But if you want a complete solution then post on the excel programming
group--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=532268