Copy all but last 9 characters of a cell

B

Ben

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!
 
C

CLR

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
 
C

CLR

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
 
Top