- In cell A2, enter the following formula:
Formula:
=LEFT(A1,LEN(A1)-9)
- Press Enter to apply the formula.
The
LEFT function takes two arguments: the first is the cell you want to extract characters from (in this case,
A1), and the second is the number of characters you want to extract. We use the
LEN function to determine the length of the cell contents in
A1, and then subtract 9 from that value to exclude the last 9 characters.
In the example you provided, the formula would look like this:
Formula:
=LEFT("Orange B Apple 123",LEN("Orange B Apple 123")-9)
This would return
"Orange B" in cell A2.