RE: [PcTech] Quick Way to Delete Large amount data in Word

["Jones, John (US)" <John.Jones@xxxxxxxxxxxxxxxxxxxxxxx>]

Title: Message

Start at the top.  Press Control-G (or click Edit - Go to...).  Select Line.  Excel supports 65536 rows so do something like 65000.  Once the cursor is on that line, press Shift-Control-Home to select everything from there back to the top.  Now cut/paste into Excel or copy into a blank Word doc or whatever.  Delete the block & repeat as necessary.

 

-----Original Message-----
From: Mark Allen [mailto:mallen@xxxxxxxx]
Sent: Friday, August 22, 2003 9:55 AM
To: pctech@xxxxxxxxxxxx
Subject: [PcTech] Quick Way to Delete Large amount data in Word

I've got a HUGE CSV file (too many rows to open in Excel) that I need to break up into Excel-able (hey I invented a new word!!) sizes.

 

My thoughts were to open it in Word, select a chunk of data, copy/paste it into another doc and save.

 

Problem is even using the fast scroll trick while selecting it is taking FOREVER to select the chunk.  Is there a quicker way?

 

Mark Allen

IS Manager

Wilkes Telephone & Electric

11 W. Court Street

Washington, GA 30673

Phone: (706) 678-9565

Fax: (706) 678-1000

 

This email is for the use of the intended recipient(s) only. If you have received this email in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. The information contained in this communication may be confidential and may be subject to the attorney-client privilege.