=LEFT(A1,4)
will take the 4 first chars from A1

=MID(A1,5,256)
will cut them off

HTH
--
AP

"Jennifer" a écrit dans le message de
news: ...
I am trying to take the first 4 contents of a cell and cut and paste it to
an
empty cell. I need a formula that will do this. I am looking at 1000
rows
that need this done. Any suggestions