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