Advanced Search

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.

Expand | Embed | Plain Text

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.