extra rows

C

Chi Huynh

when i copy a file from Microsoft Word and paste the
file to Excel, there are empty rows which are between the
records. How can I delete these empty rows so that I will
have continous list?
Example:

1. 2562
2. nothing
3. 1212
4. nothing
5. 4545
6. nothing
..... so on like that.

I like my list : 2562
1212
4545
Thank you
Chi
 
K

Ken Wright

Is there truly nothing in the cells? If so, then select the entire area of data and blanks, do
Edit / Go To / Special / Blanks, and then do Edit / Delete / Entire row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

turn rows into columns 4
Merging from an Excel file with graphics 1
I have lost 6 months work, how can i get my file back 1
Drop down list control value in vba 2
Development combinations with exclusion of columns 0
Date & Phone Manipulation 2
Getting Radio Buttons to work, that are inserted via AutoText 0
Looking for the value that indicates last row number that has filled cells 5

Top