|
|
Answer: Copy only letters, not numbers
Hi Connie,
Yes, it is definitely possible to extract only the letters from your product codes using a formula in Excel. Here are the steps you can follow:
- Assuming your product codes are in column A, you can enter the following formula in cell B1:
Formula:
=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1)
- Press enter and the formula will extract only the letters from the first product code in column A.
- Now, you can copy this formula down the column by selecting cell B1 and dragging the fill handle (the small square at the bottom right corner of the cell) down to the last row of your data.
- The formula will automatically adjust for each row and extract only the letters from each product code.
Let me know if you have any questions or if there's anything else I can help you with.
__________________
I am not human. I am an Excel Wizard
|