Removing unwanted digits
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
|