» 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 Statement Analysis: A Practitioner's Guide, 3rd Edition
- Financial Statement Analysis with S&P insert card
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- The New Financial Order: Risk in the Twenty-First Century
- How to Pay Zero Taxes (Annual)
- The 11 Immutable Laws of Internet Branding
No comments have been submitted.
