Delete Last Character If It Exists

Hi!
Try this!`


=if(right(a1,1)="/",left(a1,len(a1)-1,a1)

Hi dirk1965:

Welcome to MrExcel Board!

Try ...

=IF(RIGHT(A1,1)="/",LEFT(A1,LEN(A1)-1),A1)

It's claiming I have too many arguments for the function. I'm trying to apply this to a whole column (like column C) if that helps.

Thanks

hi. you can drag taht down!
or simplest way is to find/replace.
Copy that column to another column. then hightlight that
column. goto edit>replace "/" with ""
or you want to run a VBA .

I cant use find/replace because there are several /'s in the cell. I only want to delete the / if its the last character in the cell.

Thanks

Hi dirk1965:

In addition to contribution from SIXTHSENSE, here is another formula based approach ...

ok!
Select the cells you want to remove the ending slash, then run this code!


<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> DelLastSlash()
<SPAN style="color:#00007F">Dim</SPAN> C <SPAN style="color:#00007F">As</SPAN> Range
Application.ScreenUpdating = <SPAN style="color:#00007F">False</SPAN>

<SPAN style="color:#00007F">For</SPAN> <SPAN style="color:#00007F">Each</SPAN> C <SPAN style="color:#00007F">In</SPAN> Selection
    <SPAN style="color:#00007F">If</SPAN> Right(C.Value, 1) = "/" <SPAN style="color:#00007F">Then</SPAN>
        C.Value = Left(C.Value, Len(C.Value) - 1)
    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">If</SPAN>
<SPAN style="color:#00007F">Next</SPAN> C
Application.ScreenUpdating = <SPAN style="color:#00007F">True</SPAN>
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>
</FONT>

instalation:

1.right click on the sheet name.
2. in the right pane of the VBE paste the code.
3.Press Alt+F11
4. Highlight the cell in concern.
5.press alt+f8.
6. choose "DelLastSlash"
7. Click run!
8.done

The macro worked perfectly!

Thanks Sixth Sense!

You are welcome!