Thread: How do I cut column back to first 2 characters? Thanks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CaptainQuattro
 
Posts: n/a
Default How do I cut column back to first 2 characters? Thanks

You may not need to paste at all

Assuming the data you want to copy is in column A:

In cell B1 enter the formula =Left(A1,2)

Copy this down as many rows as you need.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=539154

Reply With QuoteReply With Quote