/ Published in: Visual Basic
Replace 'A1' with the cell and '-' with the character you want to remove.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
=IF(RIGHT(A1,1)="-",LEFT(A1,LEN(A1)-1),A1)
=IF(RIGHT(A1,1)="-",LEFT(A1,LEN(A1)-1),A1)