VBA – Space

  • Post author:
  • Post category:VBA
  • Post comments:0 Comments

The Space function fills a string with a specific number of spaces. Syntax space(number) Parameter Description Number − A required parameter. The number of spaces that we want to add to…

Continue ReadingVBA – Space

VBA – Replace

  • Post author:
  • Post category:VBA
  • Post comments:0 Comments

The Replace function replaces a specified part of a string with a specific string, a specified number of times. Syntax Replace(string,find,replacewith[,start[,count[,compare]]]) Parameter Description String − A required parameter. The Input String…

Continue ReadingVBA – Replace

VBA – Len

  • Post author:
  • Post category:VBA
  • Post comments:0 Comments

The Len function returns the length of the given input string including the blank spaces. Syntax Len(String) Example Add a button and add the following function. Private Sub Constant_demo_Click() Dim…

Continue ReadingVBA – Len

VBA – Trim

  • Post author:
  • Post category:VBA
  • Post comments:1 Comment

The Trim function removes both the leading and the trailing blank spaces of the given input string. Syntax Trim(String) Example Add a button and add the following function. Private Sub…

Continue ReadingVBA – Trim

VBA – Rtrim

  • Post author:
  • Post category:VBA
  • Post comments:0 Comments

The Rtrim function removes the blank spaces from the right side of the string. Syntax RTrim(String) Example Add a button and add the following function. Private Sub Constant_demo_Click() Dim var…

Continue ReadingVBA – Rtrim

VBA – Ltrim

  • Post author:
  • Post category:VBA
  • Post comments:0 Comments

The Ltrim function removes the blank spaces from the left side of the string. Syntax LTrim(String) Example Add a button and add the following function. Private Sub Constant_demo_Click() Dim var…

Continue ReadingVBA – Ltrim