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.
Bookmarks