How can I use remove spaces in a VBA procedure?

Answer by  manoj82 (9)

We can remove spaces in a VBA procedure by using the RemoveSpaces function. This function can be used in an excel worksheet to remove spaces. For example while writing an email address there should not be any spaces between the address. The function takes one argument that is the input string. The function has to be written in the query statement in excel.

Answer by  BillG (37)

You can use the following statement: str=str(Replace(str," ","")) where "str" is a string variable that you wish to operate on. This will remove every space (character 32 in ASCII) found in the text.