Thread: Replace Underscores Between Words from an Object with a Single Spa
View Single Post
  #6   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 01:19:35 -0500, "Rick Rothstein"
wrote:

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

Nice and simple
--ron
Reply With QuoteReply With Quote