- In cell A2, type the following formula:
Formula:
=LEFT(A1,LEN(A1)-9)
- Press Enter.
The
LEFT function extracts a specified number of characters from the beginning of a text string, while the
LEN function returns the length of a text string. By subtracting 9 from the length of the text string in cell A1, we get the number of characters to extract from the beginning of the string.
In the example you provided, the formula will return "
Orange B" in cell A2. This formula will work for any text string in cell A1, regardless of the number of characters or spacing.