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.

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.

Have a look at the REPLACE function in Help,
Regards,
Alan
"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.