| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting using part of the cells contents | Excel Discussion (Misc queries) | |||
| Conditional formatting using part of the cells contents | Excel Discussion (Misc queries) | |||
| Extract Part of a Cells Contents Q | Excel Worksheet Functions | |||
| Can I use cell contents as part of a formula? | Excel Worksheet Functions | |||
| Lookup part of a cells contents | Excel Programming | |||
Hybrid Mode
