View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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