formatting space---

[hiklior]

Hi ,

I am in a real problem. I have a huge file that i just gor from querying the database and i needed it on .doc or . txt format. Since the query result is a table there are lots of spaces between each word . I need only one space between each work. Is there any way to do it. Exactly one space between each word. Is there any way to format it like that.

I would appreciate your help

Hik

 

[SkipVought]

Hi,

Replace 2 spaces with one space. Perform until no more changes.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[hiklior]

Common now its 400 pages document. Is there any way to automatically format it.

 

[SkipVought]

Not without VBA.

Turn on your macro recorder and record doing it once.

Connect to a keyboard shortcut

Execute from the keyboard

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[hiklior]

View- Find and Replace.

on find rext box highlight the spaces and copy and paste it to the find text box and in replace textbox just hit the spacebar once.

and click on replace all.

Thats it. It was simple

 

[SkipVought]

Good!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}