String Functions in VBA

Posted on Aug 14, 2014 in Computer Science

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

Things on this page are fragmentary and immature notes/thoughts of the author. It is not meant to readers but rather for convenient reference of the author and future improvement.

String Repeating Functions

  1. string(12, "*") can only repeat character
  2. space(12) 12 spaces

Substring Functions

  1. left
  2. right
  3. mid
  4. InStr([start], string, substring, [compare]), 0 is returned is not found
  5. InstrRev

String Manipulation

  1. ltrim
  2. rtrim
  3. trim
  4. lcase
  5. ucase
  6. replace
  7. strconv

Special Characters

  1. vbcrlf
  2. vbcr
  3. vblf

Conversion

  1. val

programming VBA string character