Excel - Remove Characters from end of string in cell

If you have a column A, and you want to create a column B with equivalent to A minus some characters at the end of the string (in this example one but you can increase -1 to however many characters you would like to use), put this into B1 and copy down.


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