Delete all spaces from a string

[dunnes]

Hi,
im just writing a bit of VBA code in excel and wondered how i could remove all spaces from a string. I dont believe trim or ltrim/rtrim would work as these still leave spaces. An example of the string would be "Leeds_Bradford" (underscore is a space)and i want the output to be "LeedsBradford"
Any help would be great


Cheers
Mike

 

[Juan Pablo González]

Try using the Replace$() or the SUBSTITUTE worksheet function, like

myString = Application.Substitute(myString, " ", "")