Your formula looks almost perfect to me. Only thing I'd change is make it:

=LEFT(A1,MAX(0,LEN(A1)-5))

In case any of your text is less than 5 characters in length.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eric_NY" wrote:

I have some cell containing text of various lengths. I'd like to delete the
rightmost 5 characters of each cell.

What comes to mind is LEFT(A1, LEN(A1) - 5). Is there a simpler way?

I'm using Excel 2005.

Thanks.