Remove last letter from word.
Posted by Mo on October 15, 2001 11:13 AM
Hello,
I am tring to remove a last letter from a word any ideas.
E.g "Hello" becomes "Hell" or
"Mr Excel" becomes "Mr "Exce".
Thanks
Posted by Mark W. on October 15, 2001 11:17 AM
=LEFT(A1,LEN(A1)-1)
Posted by Mo on October 15, 2001 2:01 PM
Thankyou very much Mark W
