To remove the last "X" number of text characters in an excel cell...create a separate column and put the following code into the adjacent cell you want changed:
D4 is the cell that contains a text string: I love the month of May
the following formula =LEFT(D4,LEN(D4)-2) will go in cell E4
The formula will remove the last 2 characters in the above italicized text string to display this:
I love the month of M
