Home > Forum Home > Presenting and Reporting Data > Removing the last two characters from a string Share

Removing the last two characters from a string

Excel Help for Removing The Last Two Characters From A String in Presenting and Reporting Data


Forum TopicPost Reply Login

Removing The Last Two Characters From A String

Rate this:
(3/5 from 18 votes)
FedupI want to remove the last two characters from each cell independent of the length of the cell string. I have already tried using the RIGHT and MID functions with no sucess. Please help.
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Happy
Rate this:
(3.1/5 from 22 votes)
You can remove the last characters from a cell's text string by combining the LEFT and LEN (length) functions.

The following spreadsheet extract shows an example of removing two characters.

Excel Spreadsheet:
 ABC
1 Text: Formula: 
2 ABCDEFG =LEFT(A2,LEN(A2)-2) 
3   

The result of the formula in cell B2 is 'ABCDE' with the 'FG' removed.

 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Removing the last two characters from a string in the