| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
=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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cleaning Product Code list | Excel Worksheet Functions | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| my computor crashed and I lost my product code to reinstall how c. | Excel Discussion (Misc queries) | |||
| If statement needed | Excel Worksheet Functions | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Linear Mode
