deleting space in a string?

[MrBojangals]

Does anybody know a piece of code I can use to delete all the blank space within a string. for example say mystring = "hello how are you" I would want to change the value of mystring to = "hellohowareyou".

Thanks in advance

 

[just_jon]

=SUBSTITUTE(A1," ","")

Where A1 hods your string.

 

[Joe4]

Why not just use Replace (under the Edit menu), and replace all spaces " " with nothing?

 

[DRJ]

Or if you want to do this from VBA then:

MyText = "Hi How Are You"
NewText = Application.WorksheetFunction.Substitute(MyText, " ", "")

 

[MrBojangals]

sweet thanks
I got the subsitute code to work