» Replacing Substrings with Numbers from Adjacent Cells
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem:Replacing the "XX" substring in each of the strings in column A with the corresponding number from column B.
Solution:
Use the LEFT, FIND, and MID functions as shown in the following formula:
=LEFT(A2,FIND("XX",A2)-1)&B2&MID(A2,FIND("XX",A2)+2,255)
Book Store:
Recommended Books:
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Windows XP Pocket Reference
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- The 22 Immutable Laws of Branding
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
No comments have been submitted.
