Thread: Replace Underscores Between Words from an Object with a Single Spa
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Replace Underscores Between Words from an Object with a Single Spa
Thanks... the worksheet TRIM function has a definite advantage over VB's
Trim function for this particular question.

--
Rick (MVP - Excel)


"Ron Rosenfeld" wrote in message
...
On Wed, 31 Dec 2008 01:19:35 -0500, "Rick Rothstein"
wrote:

S_without_underscores = WorksheetFunction.Trim(Replace(S, "_", " "))

Nice and simple
--ron

Reply With QuoteReply With Quote