Use the LEFT function. E.g.,

=LEFT(A1,2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"stumped" wrote in message
...
Hi, I have a product code. The first 2 letters are significant.
How can I
capture the first 2 characters in a different cell?