Hi usmleboy,
If D2 shows 10SJ-P and E2 has =LEFT(D2,LEN(D2)-2) then in E2 you should
see 10SJ, (provided Column E is not formatted as Text).
You could then double click the fill handle, which is a fine cross that
only appears when the fat cross cursor is positioned over the bottom
right corner of the selected cell, then the formula in E2 is filled
down to the bottom of your data. You could then copy column E and
editpaste specialpaste values over the old values in column D.
Ken Johnson