| Home > Forum Home > Presenting and Reporting Data > Removing the last two characters from a string > Combine LEFT and LEN functions | Share |
Combine LEFT and LEN functions
Excel Help for Combine Left And Len Functions in Presenting and Reporting Data
| Forum Topic | Login |
Combine Left And Len Functions | 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:
The result of the formula in cell B2 is 'ABCDE' with the 'FG' removed. | |||||||||||||||||
| Excel Business Forums Administrator | ||||||||||||||||||
| Posted by Excel Helper on | ||||||||||||||||||
| View Full Post |
| Find relevant Excel templates and add-ins for Combine LEFT and LEN functions in the Excel Business Solutions Directory |