» 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 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- The One Page Business Plan: Start With a Vision, Build a Company!
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Getting to Yes: Negotiating Agreement Without Giving In
No comments have been submitted.
