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