Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Add up all Digits Within a Cell with a Line Break
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 06-09-2017, 01:52 AM
xor xor is offline Add up all Digits Within a Cell with a Line Break Windows 10 Add up all Digits Within a Cell with a Line Break Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
I understand you already have a regular formula solution, but for others it might be useful to know one possible regular formula:

=SUM(IFERROR(--(0&MID(D4,ROW(INDIRECT("1:"&LEN(D4))),1)),0))

This is an array formula which must be committed by holding down Ctrl and Shift before pressing Enter.
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interchange line break and paragraph break shortcut keys skan Word 2 01-20-2017 03:50 AM
Add up all Digits Within a Cell with a Line Break How can I remove line break from 4 dash's nmss18 Word 2 09-11-2014 06:07 AM
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal jadess916 Excel 1 06-26-2014 03:48 AM
Add up all Digits Within a Cell with a Line Break Problems merging in last 4 digits of an account higher than 16 digits Glynda Mail Merge 1 04-08-2011 12:17 AM
How to delete first 6 Digits and one Space from a CELL? Learner7 Excel 3 08-10-2010 04:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:19 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft