| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying part of a cell
can you copy part of a cell, ie i want to take the first 8 characters of a
cell and copy into another cell thanks David |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying part of a cell
Try this...
=LEFT(A1,8) -- Rick (MVP - Excel) "David" wrote in message ... can you copy part of a cell, ie i want to take the first 8 characters of a cell and copy into another cell thanks David |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying part of a cell
=left(A1,8)
"David" wrote: can you copy part of a cell, ie i want to take the first 8 characters of a cell and copy into another cell thanks David |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying part of a cell
If you really wanted to copy the first 8 characters...
You can select the cell. Hit F2 (to go into edit mode) Select the first 8 characters (in the formula bar) Rightclick|Copy (or hit ctrl-c) Hit escape to leave edit mode. And paste into the receiving cell (or even in the formula bar if you want). David wrote: can you copy part of a cell, ie i want to take the first 8 characters of a cell and copy into another cell thanks David -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search/Match/Find ANY part of string to ANY part of Cell Value | Excel Worksheet Functions | |||
| Copying part of a cell | Excel Discussion (Misc queries) | |||
| copying part of a cell's contents (formatted as dd:hh:mm) | Excel Worksheet Functions | |||
| copying part of a number string | Excel Discussion (Misc queries) | |||
| Copying Part of a row down part of a column | Excel Discussion (Misc queries) | |||
Linear Mode
