advanced code snippet search

Posted By

TheJasonParker on 01/14/11


Tagged

excel


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

qubestream


Remove a specific character from the end of a Excel cell

 / Published in: Visual Basic
 

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

Expand | Embed | Plain Text 
  1. =IF(RIGHT(A1,1)="-",LEFT(A1,LEN(A1)-1),A1)

Report this snippet  

You need to login to post a comment.