Remove a specific character from the end of a Excel cell - Visual Basic Snipplr Social Repository

Revision: 39210

at January 14, 2011 22:09 by TheJasonParker

Initial Code

=IF(RIGHT(A1,1)="-",LEFT(A1,LEN(A1)-1),A1)

Initial URL

Initial Description

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

Initial Title

Remove a specific character from the end of a Excel cell

Initial Tags

excel

Initial Language

Visual Basic