Carriage returns (Enter) in a range

Are those multiple sentences inside the same cell or 2 cells each with a sentence?

So would this get us there?
- remove ALL line breaks
- insert line break after every full stop (Period)

Do you want an empty line between each sentence?

Please Login or Register  to view this content.

Here is an better example of cell content:

Please Login or Register  to view this content.

Which would be better worded as:

Please Login or Register  to view this content.

So to your questions:
- remove ALL line breaks - Not ALL. Perhaps it should be only if the break is preceded by anything other than period or semicolon, then delete the break.
- insert line break after every full stop (Period) - This could be modified so if it is a period (or a colon or semicolon) followed by two consecutive breaks, then leave the period, but only remove one of the two breaks.
Do you want an empty line between each sentence? - No, as shown by the example.

As for my original items.

1. delete a char(10) - same as your first item - I really shouldn't do this one.
2. replace char(10) followed by a space with only one space - Think this would be better that if the sentence beings with " - " and ends with two chr(10), replace with only one chr(10).
3. replace two consecutive char(10) with only one char(10) - this one should probably be skipped as it could create other issues.

Besides the example above, another is:

Please Login or Register  to view this content.

Which should look like:

Please Login or Register  to view this content.

Maybe it would be easiest to just have it:

• if one break, delete it
• if two breaks, delete only one
• if three breaks, delete only one

See how close this gets you
Run from cell containing the text
Amended text is dumped in adjacent cell to right
Make sure receiving cell is a sensible width to prevent ridiculous row heights

Please Login or Register  to view this content.

(May need to insert an additional line break after a period and a colon etc)

OR
If you place above code in a general module, the function can be used in a normal Excel formula
So with text in cell A1, and this formula in B1

Formula:

Please Login or Register  to view this content.

Perfect! Thank you! I just modified the sub to overwrite (now that it's been tested) to:

Please Login or Register  to view this content.

When I select multiple cells, if I run the code as is, it only runs on the first cell. How do I get it to loop through each one? If I modify to below, I get a compile error (invalid or unqualified reference) with the bold:

Please Login or Register  to view this content.

Try this - overwrites selected cells

Please Login or Register  to view this content.