LEFT |
LEFT(string, length) |
Returns a substring from the left of a string (Variant / String). |
string | The text string (String). |
length | The number of characters to return (Long). |
REMARKS |
* If "string" is Null, then Null is returned. * If "length" = 0, then a zero length string ("") is returned. * If "length" = > Len("string"), then "string" is returned. * You can use the INSTR function to return the position of a substring within a larger string, starting at the beginning. * You can use the LEN function to return the number of characters in a string. * You can use the LEFTB function to be used with byte data. * You can use the LEFT$ function to return a String data type instead of a Variant data type. * You can use the LEFTB$ function to return a String data type instead of a Variant data type. * You can use the LTRIM function to return a text string without leading spaces. * You can use the MID Function to return a substring from the middle, left or right of a string. * You can use the RIGHT function to return a substring from the right of a string. * The equivalent Excel function is Application.WorksheetFunction.LEFT * The equivalent .NET function is Microsoft.VisualBasic.Strings.Left * For the Microsoft documentation refer to learn.microsoft.com |
Debug.Print Left("sometext", 4) '= "some"
Debug.Print Left("sometext", 20) '= "sometext"
Debug.Print Left("", 6) '= ""
Dim sResult As String
sResult = Left("bettersolutions", 6)
Debug.Print sResult '= "better"
Dim sText As String
sText = "bettersolutions.com"
sResult = Left(sText, Len(sText - 4)) 'remove the last 4 characters
Debug.Print sResult '= "bettersolutions"
sText = "better solutions com"
sResult = Left(sText, InStr(sText, " ") + 1) 'returns the first word
Debug.Print sResult '= "better"
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top