» Performing Numeric Operations on Substrings
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Microsoft PowerPoint Version 2002 Step by Step
- The 11 Immutable Laws of Internet Branding
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Microsoft Windows XP Registry Guide
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
No comments have been submitted.
