How to i code in VB the Left Function. The user will enter a six character
string in the first column and i need the second column to populate with the
first three characters of the first column.

Example
Column 1 Column 2
ABC100 ABC

If i coded it in the worksheet cell B1 , it would be =Left(A1,3), but i want
to put in VB as a Worksheet change. Is this possible?

Thanks

Nathaniel W. Polky

=Left(a