Capture first 2 letters from a product code

[Guest]

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

 

[Chip Pearson]

Use the LEFT function. E.g.,

=LEFT(A1,2)


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

 

[N Harkawat]

=LEFT(A1,2)