The formula should test for the 
=right(a1,1)<>"/"
to act otherwise copy and paste as text the value at a2