» 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.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
