trim function

[Guest]

I am trying to remoove characters from a text field such as "-". The
characters are in multiple spots in the field example 30GTN080---5--KA I
want to left justify the numbers and letters without any "-". How can I use
the trim function to do this?

Thanks

 

[Rick Brandt]

I am trying to remoove characters from a text field such as "-". The
characters are in multiple spots in the field example
30GTN080---5--KA I want to left justify the numbers and letters
without any "-". How can I use the trim function to do this?

Thanks

You can't. Trim is only for removing leading or trailing spaces.

Check Help for the Replace() function. It can do what you want.

 

[Alex White MCDBA MCSE]

you don't use the trim function for this purpose, it is for removing leading
and trailing spaces

Dim strtest As String
dim strNew as string
strtest = "12122--21212122--22222"
strNew = Replace(strtest, "-", "")
MsgBox strNew

Should do the trick