Keeping lines together

[Shrishesh]

Hi, I have a small issue in Word VBA. I have copied texts from PDF into Word and some lines have broken and gone on next lines. I want to keep the lines/paragraphs together with a single white space. For example, the following :-

The quick brown fox jumped over the lazy dog.
Happiness dies when it is not shared.

should appear as

The quick brown fox jumped over the lazy dog. Happiness dies when it is not shared.

As I have not fully understood the object model of VBA Word (although good in Excel ), so I am unable to do it.

Thanks in advance for giving your valuable time.

[koolsid]

Welcome to the forums Shrishesh

How are you copying the data into word document?

[Shrishesh]

Welcome to the forums Shrishesh

How are you copying the data into word document?

I have simply selected the pdf file and pasted it into word file and saved it.

[koolsid]

I see. In that case you will have to upload your file so that I can have a look. We might have to write a macro which looks for a special charater and delete it so that the lines are concatenated.

[Shrishesh]

I see. In that case you will have to upload your file so that I can have a look. We might have to write a macro which looks for a special charater and delete it so that the lines are concatenated.

A portion of that i paste here

Event
1970
C odd defines relational database model
1974
I BM's System/R project begins
1974
F irst article describing the SEQUEL language
1978
System/R customer tests
1979
Oracle introduces first commercial RDBMS
1981
R elational Technology introduces Ingres
1981
I BM announces SQL/DS
1982
A NSI forms SQL standards committee
1983
I BM announces DB2
1986
A NSI SQL1 standard ratified
1986


Thanks

[koolsid]

Shrishesh

This will not help as when you copy data into word from pdf, I believe some special characters are also copied which get lost when you are pasting it here in this forum and hence I wanted to see the word file