How do I cut column back to first 2 characters? Thanks
 

After pasting data into a new Excel column, I need to limit the new Column to
first 2 characters only.

Thanks

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