Advanced Search

Return to Snippet

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