G
Guest
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
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