Capture first 2 letters from a product code

stumped · May 18, 2005

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 · May 18, 2005

Use the LEFT function. E.g.,

=LEFT(A1,2)

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

N Harkawat · May 18, 2005

=LEFT(A1,2)