Copy all but last 9 characters of a cell

[Guest]

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!

 

[Guest]

I figured it out myself for once!

=LEFT(a1,LEN(a1)-9)

 

[Guest]

Try

=LEFT(A1,(LEN(A1)-9))

Mike

 

[Guest]

That's great Ben, but be aware that with your sample data you will also
return an invisible trailing space after the "Orange B "

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Sorry, forgot to mention one way to get rid of that trailing space would
be......

=TRIM(LEFT(A1,LEN(A1)-9))

Vaya con Dios,
Chuck, CABGx3