Remove a specific character from the end of a Excel cell


/ Published in: Visual Basic
Save to your folder(s)

Replace 'A1' with the cell and '-' with the character you want to remove.


Copy this code and paste it in your HTML
  1. =IF(RIGHT(A1,1)="-",LEFT(A1,LEN(A1)-1),A1)

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.