Thread: Copy all but last 9 characters of a cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Copy all but last 9 characters of a cell
Try

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

Mike

"Ben" wrote:

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!
Reply With QuoteReply With Quote