Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting all data in cell if value starts with 3 particular letter | Excel Discussion (Misc queries) | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
if a cell = a particular letter or even contains that letter | Excel Worksheet Functions | |||
press letter and go 2 entry begin w letter in data validation drop | Excel Programming |