Remove last character of text string
 

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.

=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.

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.


If your string is in, say, A1, this formula

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

will delete the last character of your string.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=471812