From this video you can learn how to use left function in excel vba macro.<br /><br /><br />https://drive.google.com/open?id=1xUrqmnsFN6GcS7XTJJsURBfZMsbJv79Z<br />