Remove last character of text string

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

BenjieLop

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Text 7
Copying text to new cell 4
Excel Subtract text after the third space and before the fourth (from between spaces) 3
Return the text before a | in a text string 5
Extract characters from Right of string 5
Cut the last 20 characters out of a text string 4
Help with MID Function? 20
How to extract capitalized group in text string 9

Top