Worksheet formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am pasteing text from notepad to Excel. The text coming from notepad is
double-spaced. I want to have the text going to Excel to be only
single-spaced (data in each consecutive cell.) Tried to AUTOFILTER but is
not what I am looking for. Any suggestions?
 
I'd try sorting the data. The junk may go to the bottom.

--
Jim Rech
Excel MVP
|I am pasteing text from notepad to Excel. The text coming from notepad is
| double-spaced. I want to have the text going to Excel to be only
| single-spaced (data in each consecutive cell.) Tried to AUTOFILTER but is
| not what I am looking for. Any suggestions?
 
Before sorting, I suggest the OP should add a column on the right filled with
sequential numbers, so, after getting the blanks to the bottom where they can
be deleted, you can get the remaining rows back into their original order.
 
You must log in or register to reply here.

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

Quote Marks Question 2
Excel And Notepad 3
Excel CSV Files; Creating Of 3
How to stop Excel adding quotation marks when copying to notepad? 3
How do I prevent a long string of text from wrapping in a text fil 1
Trailing Spaces in Merged Cells 1
["\r\n" new line command in CSV file] 1
line break does not appear in CSV 3

Back
Top