» Removing Redundant Characters from a Range of Cells and Resetting the Format
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Finance and Accounting for Nonfinancial Managers
- Yes, You Can Time the Market!
- The New Financial Order: Risk in the Twenty-First Century
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- The 11 Immutable Laws of Internet Branding
No comments have been submitted.
