removing last character from different size text/names

[lezawang]

Hi
I have names in one column. Lets say I wan to delete the last letter only. I was thinking to use find() and left(). Find() the space and then left() that number -1. Is there anything better?
Thank you so much.

PS: sorry that does not work. I can not find() the space " ".
Find() gave me an error message. So my idea does not work

 

[JackDanIce]

Try:=

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

 

[Aladin Akyurek]

If you want to ignore trailing spaces while removing last printable char...

=TRIM(SUBSTITUTE(A2,RIGHT(TRIM(A2)),""))

 

[JackDanIce]

@Aladin Akyurek without knowing OP's data, I tried your formula with "dddd eeeddd" and it just left "eee", does yours need the last character to be unique within the string?

 

[Aladin Akyurek]

@Aladin Akyurek without knowing OP's data, I tried your formula with "dddd eeeddd" and it just left "eee", does yours need the last character to be unique within the string?

Good catch... If trimming is still a good idea;

=LEFT(TRIM(A2),LEN(TRIM(A2))-1)