Daily Archives: September 4, 2020

Last Updated on January 11, 2023 by token 1. StrConv VBA Function – Description The StrConv VBA function  converts a text value by specified in the second argument of the parameter. With this function, you can, among other things, convert a string to uppercase like the VBA UCase function . […]

Last Updated on January 11, 2023 by token 1. StrComp VBA Function – Description The StrComp VBA function   compares the length of strings in two texts. Depending on the difference in length, the function returns the values ​​1, 0 or -1. 2. VBA StrComp Function – Syntax StrComp (String1, String2, […]

Last Updated on January 11, 2023 by token 1. Str VBA function – Description The VBA Str function   converts a numeric value to the String data type  . The simplest form of the String data type with a variable number of characters takes up as many bytes in memory as […]

Last Updated on January 11, 2023 by token 1. Space VBA function – Description The Space VBA function returns the number of spaces specified in the argument. So, if we want to get a text with only 100 spaces, enter the number 100 in the argument. 2. VBA Space function […]

Last Updated on January 11, 2023 by token 1. RTrim VBA function – Description The RTrim VBA function removes spaces from the right side of text. We use it when we want to remove unnecessary spaces from the right side of a text string. If, however, we want to remove […]

Last Updated on January 11, 2023 by token 1. RIGHT VBA function – Description The RIGHT function in VBA cuts the specified number of characters from the text starting from the right side. It can be compared to the RIGHT function in an Excel worksheet. The function cuts text from […]

Last Updated on January 11, 2023 by token 1. Replace VBA function – Description The  Replace VBA  function is used to replace strings. If we want to replace a word or a fragment of text with another, we use the Replace function. The function has additional arguments with which we […]

Last Updated on January 11, 2023 by token 1. MID VBA function – Description The MID VBA function is equivalent to the SUBSTRING or SUBSTR function in other programming languages. How does the MID function work? The VBA MID function cuts text from other text. For example, from the sentence […]

Last Updated on January 11, 2023 by token 1. LTrim VBA function – Description LTrim VBA function removes spaces from left side of text. We use it when we want to remove unnecessary spaces from the left side of a text string. If we want to remove spaces from the […]

Last Updated on January 11, 2023 by token 1. Len VBA function – Description The VBA Len function returns the string length for the given argument. How to use it? All you have to do is enter some text as an argument to the function. The function can be compared […]

Last Updated on January 11, 2023 by token 1. LEFT VBA function – Description The LEFT function in VBA cuts a specified number of characters from the text starting from the left side. It can be compared to the LEFT function in an Excel worksheet. The function cuts text from […]