Remove last character of text string

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

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 said:
I need a function to drop that last chatacter of a text string. Th
text
strings vary in length bit I always need to remove the last string
Any
suggestions?

T.I.A.
Click to expand...


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

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

will delete the last character of your string.

Regards
 
Back
Top