» Performing Numeric Operations on Substrings
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Column A contains a list of strings that are composed of two numbers separated by a "/" symbol.
We want to add 10 to the left number of each string.
Solution:
Use the LEFT, FIND, and MID functions as shown in the following formula:
=LEFT(A2,FIND("/",A2)-1)+10&MID(A2,FIND("/",A2),255)
Book Store:
Recommended Books:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- The Analysis and Use of Financial Statements
- Analyzing Markets, Products, and Marketing Plans
- Word 2002: The Complete Reference
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Marketing Plans That Work, Targeting Growth and Profitability
No comments have been submitted.
