06-03-2010, 09:33 AM
if this is the case..to get the first 5 character, you should use 'LEFT'
e.g.
e.g.
Code:
Str = "ABC12345678"
sValue = Left(Str,5)
msgbox sValue