Hi guys,
I'm in need of a way to sum/adding up numbers in a SINGLE cell that are divided by line breaks. Example:
0
6
7
0
Those 4 numbers would be in a single cell lined up vertically. How do I write a formula that will return back to me a value of "13"? I have be wrecking my brain over this trying to find a solution to no avail so far.
And before anyone asks why are my numbers line-broke in a single cell instead of occupying separate cells, these numbers are the result of an output Excel-file from an ERP, not manually entered.
Any advice would be appreciated!
Bookmarks