my previous question

  • Thread starter Thread starter Linda
  • Start date Start date
L

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
 
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
 
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
 
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/
_______
 
Back
Top