Needed to take spaces out of a string

[Bill_Biggs]

I have a string that I need to remove the space from the middle of. So if someone enters "I hope so" the string will be edited in the macro so that the new value would be "Ihopeso". Can anyone help? Ihopeso.

 

[jindon]

Hi

=Substitute(A1," ","")

 

[Bill_Biggs]

Thansk, but I need something else

Thank you, but it needs to be a macro command.

 

[stanleydgromjr]

Bill,

You could highlight the range, and click on 'Edit' Find:
In the 'Find what:' box: (hit the space bar once)
In the 'Replace with:' box (leave this box blank)

And click on the the 'Replace' button.

Have a great day,
Stan

 

[jindon]

OK

Dim myStr
myStr = "I hope so"
MsgBox Replace(myStr, " ", "")

 

[Bill_Biggs]

Eureka

Thank you, that is perfect! You guys are always so helpful.