» Replacing Substrings with Numbers from Adjacent Cells
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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:
- The 11 Immutable Laws of Internet Branding
- Analyzing Markets, Products, and Marketing Plans
- Special Edition Using Microsoft Word 2002
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- East of Eden (Oprah's Book Club)
No comments have been submitted.
