how to remove a blank line between paragraph.

[Learnerprog]

Hello all,
is there a way that you can remove a blank line between paragraph.
for example
xxxxxxxxxx yyyyyyyyyyyyyyyyyy zzzzzzzzzzzzzzzzzzzzzzzzzzzzz






aaaaaaaaaa bbbbbbbbbbbbbbbbbbbb cccccccccccccccccccccccc


how to progrmatically removed all the blank lines between those two paragraphs. Thanks

 

[TonyJollans]

It depends on what is making the blank line(s), but if it is superfluous paragraph marks the easiest way is with a Find and Replace operation:

Ctrl+H to bring up the dialog
Find ^13{2,} -- that's caret, one, three,left brace, two, comma, right brace
Replace ^p -- that's caret, lower case P
Check "Use Wildcards"
Hit Replace All


Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[Learnerprog]

I meant to code in visual basic 6.0. Thanks.

 

[PHV]

Simply use the macrorecorder while following Tony's advice.

 

[Learnerprog]

can you please give some snippets. Thanks

 

[SkipVought]

Almost anyone who would give you a snippet, would...

Open the application

Turn on the macro recorder

record find/replace as described above.


YOU can do THAT as well as anyone!

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[EBGreen]

The macro recorder gives wonderful snippets. Did you try it?

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[SkipVought]

THAT'S the Tip...
[red]
Turn on your Macro Recorder![/red]

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]

 

[Learnerprog]

I sorry all, I am new to vb.. I have never used macro recorder before. I don't even known how to turn it on. Thanks.

 

[PHV]

Have a look at he menu Tools -> Macro ->

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Learnerprog]

I have tried that but I don't see it

 

[PHV]

I have tried that
When in word main window with your document open ?

 

[Learnerprog]

I am sorry guys.. I should have posted under Visual Basic 6.0 forum. I apologize for the confusion. Thanks you.

 

[SkipVought]

Joe,

You must be in the application (like Word) in order to turn on and run the macro recorder.

Skip,
[sub]
[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount! [/sub]