» Removing Redundant Characters from a Range of Cells and Resetting the Format
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
The text values in the range A2:A5 contain redundant parentheses.
We want to create a formula that will remove the parentheses and set the format of the cells to "general".
Solution:
Use the TEXT, TRIM, and SUBSTITUTE functions as shown in the following formula:
=TEXT(TRIM(SUBSTITUTE(SUBSTITUTE(A2,")",""),"(","")),"General").
Book Store:
Recommended Books:
- The Interpretation of Financial Statements
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Finance and Accounting for Nonfinancial Managers
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Special Edition Using Microsoft Office XP
No comments have been submitted.
