my previous question

[Linda]

I got the following reply to my question, thanks a
lot! ...but I have one more question, I was wondering
how I can delete all those unnecessary empty rows in the
table after I've converted it? (a lot of empty rows
between lines) I keep deleting them till every line is
one after the other (that's also taking up more time than
I'd like
thanks
--linda

Copy the data in Excel, and paste it into Word
In Word, select the table that contains the data
Choose Table>Convert>Table to Text
Select one of the separation options, click OK

 

[Guest]

I've tried Table --> Sort, but it rearranges all my
lines...so any better ideas?

 

[Don Guillett]

Linda,
It is best to stay in the ORIGINAL thread and use meaningful subject lines.

 

[Jon Peltier]

Why not do it in Excel before the copy. Chip Pearson shows how:

http://cpearson.com/excel/deleting.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

thanks, wow seems complicated, or maybe I just don't know
how to read their explanations....I'll just stick with
Table --> Sort, and we'll see
thanks though
--linda

 

[Debra Dalgleish]

To manually delete the blank rows in Excel:

Select a column that has blank cells
Choose Edit>Go To
Click the Special button
Select Blanks, click OK
Choose Edit>Delete
Select 'Entire Row', click OK

 

[Jon Peltier]

It seems hard to do some of these things. Make a copy of your workbook,
so you're not afraid of trashing it, then work through the steps
carefully. After one or two tries, it might even make sense. Or read on,
and someone will propose a different approach. Eventually, one will make
sense to you, and that's how you'll do it.

(I see Deb's chimed in with another approach...)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______