I want to remove space between lines!!

I want to remove space between lines!!

Where can i do it!!

for e.g

asdfghjkl

qwertyuio

qwertyuio

I want to change this to


asdfghjkl
qwertyuio
qwertyuio

In my job I have to remove spaces for thousands and thousands of lines!!

I tried it in Word 2007 by selecting all and then clicking No spacing
but the space cant be removed!

Anybody pls help me !!

 

Think about putting them into excel and getting someone to write a Macros (VBScript) for that. It should be very easy for a VB Coder. I tried, but I have no experience with it.

 

Make a .pdf with all those lines, save it, then there should be an option like view text only, that should work; I'm not sure though... only guessing.

 

Ok, let's say I'm not a programmer at all and I have never written Excel Macros, but it started to get interesting for me, so I decided to try and see if I can do it.

So I did some research and wrote this code that works for this task:

   Dim i As Integer

    For i = 2 To 20
    
    Rows(i).Select
    Selection.Delete Shift:=xlUp
    
    Next i

Code (markup):

First paste your lines into Excel starting from Cell A1.

Then change the "To 20" of the code to the number of rows you have in your table after pasting your lines. Sorry for not making it simpler, but I really don't have any experience, only curiosity and desire to help

So to the point...in Excel 2003 you should click Tools/Macro/Macros...write a name for your macros and click create. The visual basic editor opens and this is where you should paste the code I created.

After that just run the macro and see if it works. I tested it several times here and it worked as expected.

I don't have Excel 2007 installed, but you should be able to find out how to create a macro there.


Hope it helps

 

Remove spacing from this...or copy in note pad the remove line...

 

I never thought of a job like this.

By the way nice for you. I hope you would get a way to overcome this problem.

 

thats the easiest way,
open notepad,paste all text ,ctrl+h ,replace space " " with nothing its done

 

Go to >> Format >> Paragraph > Line Spacing
Check what happen ?

 

you can do this with notepad++ easily
see hidden codes in notepad and then replace the words which is appearning in this space with nothing

 

i hope somebody gives u a honest reply for such a tedious job

 

here is the correct and better solution to your problem (google search)

This depends on whether those are really empty lines or your line spacing is set to 2. Try this (with Word XP (2002) and the adjacent versions. Word Vista probably has something similar):

1. Select all the text with CTRL/A.
2. Right-click in the text and select Paragraph.
3. Under Spacing, make sure Before and After have zeroes and Line Spacing has "Single" with At blank.
4. Click OK.

If this fixes your problem, your spacing was double spacing. If it doesn't fix the problem, do this:

1. On the menu bar, click the button that looks like ¶. This will turn on hidden formatting characters. The ¶'s that appear show the ends of each paragraph. If there are extras between your lines, you can do a mass delete them this way:
2. Press CTRL/H to bring up the Find and Replace dialog box.
3. In the Find what, put ^p^p
This represents two adjacent paragraph marks.
4. In the Replace With, put a single ^p
5. Click the Replace All button.

6. Click the ¶ button again to turn off the hidden characters.

Hope that helps.