Thread: Copying part of a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default 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

Reply With QuoteReply With Quote