» Summing Values in a Range Containing Redundant Spaces
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
The numbers in column A contain redundant spaces.
If we try to calculate a total using the SUM function, 0 is returned.
Solution:
Use the SUM, VALUE, and SUBSTITUTE functions as shown in the following Array formula:
{=SUM(VALUE(SUBSTITUTE(A2:A4," ","")))}

Book Store:
Recommended Books:
- East of Eden (Oprah's Book Club)
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Microsoft Excel VBA Programming for the Absolute Beginner
- Marketing Plan: A Handbook with Marketing Plan
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- The Basics of Finance: Financial Tools for Non Financial Managers
No comments have been submitted.


