=IF(A1<"",LEFT(A1,LEN(A1)-1),"")


On Thu, 29 Sep 2005 08:35:03 -0700, "Grant" wrote:

I need a function to drop that last chatacter of a text string. The text
strings vary in length bit I always need to remove the last string. Any
suggestions?

T.I.A.