Thread: formula that takes part of a cells contents to another
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Scoops Scoops is offline
external usenet poster
  
Posts: 108
Default formula that takes part of a cells contents to another

Jennifer wrote:
I am trying to take the first 4 contents of a cell and cut and paste it to an
empty cell. I need a formula that will do this. I am looking at 1000 rows
that need this done. Any suggestions

Hi Jennifer

Try:

=LEFT(A1,4)

Regards

Steve

Reply With QuoteReply With Quote