Space after period.

[topi1]

Trying to find a vba which will add a space between sentences if none exists. To clean up texts, email etc. for a column or entire sheet.Tried to learn about patterns but could not figure out how to do that on my own. Dr. Google didn't help either. Thank you.

 

[Special-K99]

Pls ignore this reply.

 

[DipDip]

Howdy,
Would you not just run 2 find and replace macros? One which searches for a period "." and replaces it with a period followed by a space ". " Then your second find and replace would look for 2 consecutive spaces " " and replace with one " "?

 

[Special-K99]

Howdy,
Would you not just run 2 find and replace macros? One which searches for a period "." and replaces it with a period followed by a space ". " Then your second find and replace would look for 2 consecutive spaces " " and replace with one " "?

Isn't it just replace "<non-space character><full stop><non-space character>" with "<full stop><space>"

 

[DipDip]

Isn't it just replace "<non-space character><full stop><non-space character>" with "<full stop><space>"

Or that. I'm not sure how do to it via VBA. With my current knowledge, I'd just get 2 macros and get the VBA to run them when needed.

 

[topi1]

Howdy,
Would you not just run 2 find and replace macros? One which searches for a period "." and replaces it with a period followed by a space ". " Then your second find and replace would look for 2 consecutive spaces " " and replace with one " "?

But of course. Simple but brilliant! Can't believe I didn't think of it. That is what happens when you think help is round the corner. You get lazy! Thank you much. I also added the same thing for ! and ?.