• Home
 · 
• String Manipulation
 · 
• Selects every character from the left side of a string, up until a specified character.

Selects every character from the left side of a string, up until a specified character.

Selects every character from the left side of a string, up until a specified character.

Rate Selects every character from the left side of a string, up until a specified character.

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

If Trim(str) = "" Or Character = "" Then Exit Function
'get the selection if the character exists, if it doesnt,Left() returns an empty str
Left2Char = Left(str, InStr(1, str, Character, CompareMode))
End Function