Monday 1 December 2014

Trim String using VBA

Sub TrimString()

Dim Trim1 As String

Trim1 = Trim ("      Trim Data   ")

Range("A1").Value = Trim1

End Sub

No comments:

Post a Comment