=LEFT(A1,10)

will return the 10 left-most characters in cell A1.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Novice" <Novice @discussions.microsoft.com wrote in message
...
Does anyone know how to copy only certain characters from cell to cell?
For
instance, I am trying to copy the first 10 characters from a cell to a new
cell.