VBA - delete all spaces from a string

[ferret]

Hey there,
I have a string (strTemp) which is data entered by a user via a form.
Is there a way to delete all spaces(occurances of " ") in the string before i go ahead to process it?

 

[eliW]

On 2002-12-11 11:31, ferret wrote:
Hey there,
I have a string (strTemp) which is data entered by a user via a form.
Is there a way to delete all spaces(occurances of " ") in the string before i go ahead to process it?

Use the SUBSTITUTE formula on your string to substitute any " " to ""

Eli

 

[Richie(UK)]

Hi ferret,

Try : strTemp = Trim (strTemp)

Also, look at Trim in the VBE Help as you can also use left and right variations if needed.

HTH