See the Left, Right, Mid, and Trim functions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"windyoldman" wrote in
message
...
I am working with a large volume of data and have numerous
occasions where I
need to trim either from the left or the right specific number
of characters
of a string of characters. I imagine this could be done in VB
but I am not a
VB expert.