View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Replace Underscores Between Words from an Object with a Single Spa

I'm thinking this might be more what you are looking for. When I ran Chip's
code, I got a string without spaces at all.

Sub merge()
Dim S As String
S = "Your_String"
S = Replace(S, "_", Space(1))
MsgBox S
End Sub

"TomP" wrote:

I have an object that is filled with many underscores between texts. I
recently got help from your forum on how to remove leading underscores which
works great and now I need help in replacing a line of underscores between
words with a single space.

Thank you again for your help!