» 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:
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Marketing Plan: A Handbook with Marketing Plan
- Seven Habits Of Highly Effective People
- Financial Risk Manager Handbook, Second Edition
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
