I have values + spaces in cell A1. I would like cell A2 to display all the
values EXCEPT the last 9. the number of characters in cell A1 can vary.

I know how to use the =RIGHT formula to show the last 9, but I don't know
how to use it to show all but the last 9.

For example, cell A1 = Orange B Apple 123. I would like A2 to = Orange B.

The # of characters and spacing will vary.

Thanks!