formula that takes part of a cells contents to another
 

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

formula that takes part of a cells contents to another
 

=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

formula that takes part of a cells contents to another
 

Hi Jennifer,

Assuming that your data starts in A1, try:

=LEFT(A1,4)

and copy down as far as required.



---
Regards,
Norman



"Jennifer" wrote in message
...
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

formula that takes part of a cells contents to another
 

Jennifer wrote:
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

Hi Jennifer

Try:

=LEFT(A1,4)

Regards

Steve