Chuck,

try

="0"&mid(a3,5,2)

hope its help

Marcelo from Brazil

"ChuckNC" escreveu:

it doesn't appear to be a simple text to columns function. here's what i want
to do:

i have cell that contains :02110610 and I want to reduce it to 010. is there
a formula, or the like, that will strip out the the first four characters
(:021) and the last three characters (610) and then add a zero, so i end up
with 010? can i do this in a column on one row and then drag it down +/- 2300
rows of data? thanks a multitude, in advance, for your help, folks.
-chuck

p.s. pls forgive my ignorance of the proper language for this stuff.