What I'd like to do is, if the last letter of what is inputed into a cell is the "+" symbol. Then delete it. I have a cell defined by: Sheet12.Cells(11, 2) = d & "+" + l & "+" + w & "+" + s Here's what i get fromt that cell. ..5D + 2L + 3W + 2S if i change it and s = 0 i get ..5D + 2L + 3W + i want to get ..5D + 2L + 3W So i was hoping maybe there was a command, to delete a space off the end of a cell using and IF statement. IF last letter is a "+" , delete 1-2 spaces of the end of the cell.
