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
|