You asked for a formula to remove the first 3 and the last 2 digits from a
12 digit number.
Now you seem to have changed your mind and want to remove the first 2 and
last 3 characters from a 10 character string.
In that case instead of =MID(A1,4,7) you'll need =MID(A1,3,5).
If you don't know that your string is going to be 10 characters, but want to
remove the 1st 2 and last 3 from a string of unknown length, then use
=MID(A1,3,LEN(A1)-5)
--
David Biddulph

"bill" wrote in message
...
thanks for the response david.

let me explain a little further..

For example... currently I have the following in cell A1... H016690180

I wish to remove the H0 from the beginning and the 180 from the end....

Is this possible to have excel perform this automatically?

thanks again,

Bill

"David Biddulph" wrote:

=MID(A1,4,7) and copy down.
--
David Biddulph

"bill" wrote in message
...
Hi,

i'm not sure how to explain this but here goes...

i have cells containing 12 digit numbers. I need to remove the first 3
and
the last 2 digits. As there are 1000 plus cells (all in the same colum)
which
i need this to occur is there a way to automate this inexcel?

thanks,

Bill