View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin O'Neill[_2_] Kevin O'Neill[_2_] is offline
external usenet poster
 
Posts: 44
Default Deleting last letter if a cell

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.