Hi
try a formula such as
=LEFT(A1,5)

--
Regards
Frank Kabel
Frankfurt, Germany


jrholmesj wrote:
I have a large column of cells. I would like to cut and paste the
first five digits of each of the cells in this column, without
cutting and pasting the remaining cell info. How is this done?