rickydoyle
asked on
Trim Function
Is it possible to use a Trim function and a Ucase Function on the same line of code? If so how?
rickydoyle,
You can conbine any number of functions together in the same line... including the mixture of your custom functions, VB standard functions, and API declared functions. For example :
MyVariable = MyFunction(Left(Trim(TestV ariable),2 ))
HATCHET
You can conbine any number of functions together in the same line... including the mixture of your custom functions, VB standard functions, and API declared functions. For example :
MyVariable = MyFunction(Left(Trim(TestV
HATCHET
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
dim strStringTwo
strStringOne = " HelLo TherE "
strStringTwo = UCase(Trim(strStringOne))
This gives you "HELLO THERE" for strStringTwo.
Hope this helps -- b.r.t.