View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Replace Underscores Between Words from an Object with a Single Spa

On Wed, 31 Dec 2008 11:43:08 -0500, "Rick Rothstein"
wrote:

Thanks... the worksheet TRIM function has a definite advantage over VB's
Trim function for this particular question.


Assuming, as you pointed out, that the OP wants all <multiple spaces in the
document to be condensed to a single <space.
--ron