replace several spaces with single space

[Robie]

Hi

How can easily replace 2 or more spaces between words with a single space?

Also, is there a way I can delete a table row if all columns are empty? Can I use a Find/Replace of some sort to do this or do I need to write some VBA that process all tables/rows checking for empty cell and deleting the row? :-(

Thanks.
Robie

[DaveA]

Do you mean 2 or more spaces, other wise the words would run together?

If it 2 or more, just do a Replace of 2 spaces for 1. This may need to be run several times.

I would sort the table, and all of the blank rows would be grouped and the you could select and delete them.
But then you would need to resort to back to the way it was before the first sort.

[Robie]

Do you mean 2 or more spaces, other wise the words would run together?

If it 2 or more, just do a Replace of 2 spaces for 1. This may need to be run several times.

I would sort the table, and all of the blank rows would be grouped and the you could select and delete them.
But then you would need to resort to back to the way it was before the first sort.

Thanks for the response Dave.
Basically, I would like to replace 2 or more spaces between words with a single space. Sorry, my original post was not clear.

[Robie]

Update to my OP:

I have managed to find an old macro which removes empty rows from the table. So, i will try to use that one.

Thanks.

[Rudi]

How can easily replace 2 or more spaces between words with a single space?

Try this:

1. Press Ctrl+H to open the Find and Replace dialog box.
2. Click the More button to display the search options.
3. Select the Use wildcards check box (this method won’t work unless this option is turned on).
4. In the Find what field, press the spacebar once followed by {2,}. (Two spaces minimum followed by a comma indicating any amount maximum)
5. In the Replace with field, press the spacebar once.
6. Click Replace All.

[HansV]

Even easier (but it may not always do what you want):
- Press Ctrl+H to activate the Replace dialog.
- Enter ^w in the 'Find what' box. This stands for 'white space' - any combination of spaces and tab characters.
- Enter a single space in the 'Replace with' box.
- Click 'Replace All'.

[Robie]

How can easily replace 2 or more spaces between words with a single space?

Try this:

1. Press Ctrl+H to open the Find and Replace dialog box.
2. Click the More button to display the search options.
3. Select the Use wildcards check box (this method won’t work unless this option is turned on).
4. In the Find what field, press the spacebar once followed by {2,}. (Two spaces minimum followed by a comma indicating any amount maximum)
5. In the Replace with field, press the spacebar once.
6. Click Replace All.

Thanks Rudi. That works wondefully well.

[Robie]

Even easier (but it may not always do what you want):
- Press Ctrl+H to activate the Replace dialog.
- Enter ^w in the 'Find what' box. This stands for 'white space' - any combination of spaces and tab characters.
- Enter a single space in the 'Replace with' box.
- Click 'Replace All'.

You are right Hans. This is even easier. Like it very much.