VBA Left Function – How to use Left

Published by admin on

1. Left VBA Function – Description

The VBA LEFT function in Excel return a specified number of characters from the text, begining from the left side. It can be compared to the LEFT function in Excel worksheet. How does the LEFT function work? The function return text from another text starting from the left side. For example, from the sentence “I’m the best programmer” we can return word “I am”.

2. VBA Left Function – Syntax

String – The text string from which we cut text from the left side.

Length – We can specify in this argument how many characters from the string we want to return.

Function returns: String / text value

3. Left VBA Example

Here is an example of using the LEFT function in the VisualBasic Editor. You can paste it into Code window.

VBA Functions - VBA Left Function

VBA Functions – VBA Left Function

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: