Here is code to emove a specific character from the end of a Excel cell. Replace 'A1' with the cell and '-' with the character you want to remove. I found it very useful.
Here is code to emove a specific character from the end of a Excel cell. Replace 'A1' with the cell and '-' with the character you want to remove. I found it very useful.
Code Snippet:
IF(RIGHT(A1,1)="-",LEFT(A1,LEN(A1)-1),A1)
ActionScript - ActionScript 3 - Apache - AppleScript - ASP - Assembler - Bash - C - C# - C++ - ColdFusion - CSS - Delphi - DOS Batch - Fortran - HTML - iPhone - Java - JavaScript - jQuery - Lisp - MatLab - Maxscript - MXML - MySQL - Objective C - Other - Pascal - Perl - PHP - PL SQL - Prolog - Pseudocode - Python - Rails - SmallTalk - Smarty - SML - SPSS - SQL - SVN - Symfony - TCL - VB.NET - Visual Basic - XHTML - XML - XSLT
© 2000-2015 Xentrik.Net