Thread: Word wrap issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Agnes_Farm Agnes_Farm is offline
external usenet poster
 
Posts: 1
Default Word wrap issue

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.