I tried a few things when you first posted this. I failed.

It sounds like no one has an answer that'll work.

Agnes_Farm wrote:

Is there a way to alter the word wrap feature so that it does not use the
hyphen (-) to drop the text to the next line. For example, the phrase "The
cost is approx. $10MM which is a variance of -$5MM." should wrap as follows:
"The cost is approx. $10MM which is a variance of
-$5MM."

but currently wraps as:
"The cost is approx. $10MM which is a variance of -
$5MM."

I know I can manually correct with ALT Enter but I have several of these in
mutliple tabs and wanted to see if there was a way (like through VBA) that
could automatically change the wrap.

--

Dave Peterson