Home
Templates
Project Management
Business Valuation
Real Options Valuation
Regression Forecasting
Portfolio Tracking
Portfolio Optimization
Excel Invoice Template
Bond Yield Calculation
Optimal Hedging Strategy
Purchase Templates
Solutions
Excel Business Solutions
Business Finance
Financial Markets
Operation Management
Excel Productivity
Free Excel Solutions
Benefits of Excel Solutions
Convert VBA to OO Basic
PC Optimization Tools
Useful Resources
Support
Quick Answers
Excel Help Forums
User Guides
Send Feedback
About Us
Partner Program
Education Program
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 Topic
Post Reply
Login
Removing The Last Two Characters From A String
Rate this:
(
3
/5 from
18
votes)
I 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
Dave
on
10 Mar 2006
Replies - Displaying 1 to 1 of 1
Order Replies By:
Most Recent
|
Chronological
|
Highest Rated
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:
A
B
C
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
Excel Helper
on
10 Mar 2006
Displaying page 1 of 1
Find relevant Excel templates and add-ins for
Removing the last two characters from a string
in the
Excel Business Solutions Directory