Skip to content

Instantly share code, notes, and snippets.

@philo-ng

philo-ng/gist:279615dc3dfad90e2a4c

Created February 9, 2016 18:01
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save philo-ng/279615dc3dfad90e2a4c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save philo-ng/279615dc3dfad90e2a4c to your computer and use it in GitHub Desktop.
Download ZIP
Calling the VBA Trim function from Excel Cells
Raw
gistfile1.txt
'
' The Excel built in function Trim removes excessive spaces in the string. It may cause data
' problem. The VBA Trim function only remove the leading and trailing spaces.
'
Public Function VBA_Trim(value As String) As String
VBA_Trim = Trim(value)
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment