Worksheet Function Vba Left. VBA makes Excel's worksheet functions available through the WorksheetFunction object, which is contained in the Application object. The LEFT function is a built-in function in Excel that is categorized as a String/Text Function.
VBA Reference - String Functions Asc Chr CStr Format InStr InStrRev.
The LEFT function returns the specified number of characters in a text string, starting from the first or left-most character.
I know I could just record macro to left and copy paste, but I was wondering if there was a way to do it with vba without actualy doing anything inside. It can be used as a worksheet function (WS) and a VBA function (VBA) in. Visual Basic for Applications (VBA) has many built-in functions that help you work with spreadsheet data.