ExcelBanter - Capture first 2 letters from a product code

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Capture first 2 letters from a product code (https://www.excelbanter.com/excel-worksheet-functions/26725-capture-first-2-letters-product-code.html)

stumped

Capture first 2 letters from a product code

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

"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?

N Harkawat

=LEFT(A1,2)

"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?

All times are GMT +1. The time now is 07:45 PM.