Forum Discussion
Solved
sum Function
Hello everybody, I would like to count the amount of numerics (1-10) in a row, count it without commas, but I have to take into account that in one cell is more than one number like 1,2,4,7,9 8,...
Hi Niklas,
Better to republish your question on Excel community here in Formulas & Functions space.
Anyway, simular question was discussed here, the only number numbers are separated by Alt+Enter, not comma. Here is about formulas https://techcommunity.microsoft.com/t5/Excel/Calculate-simple-equation-which-is-included-in-one-cell/m-p/41382/highlight/true#M235
and that is G&T approach https://techcommunity.microsoft.com/t5/Get-and-Transform-Data/Get-amp-Transform-solving-all-sorts-of-Excel-issues/m-p/46208/highlight/true#M40
Hi Niklas,
Better to republish your question on Excel community here in Formulas & Functions space.
Anyway, simular question was discussed here, the only number numbers are separated by Alt+Enter, not comma. Here is about formulas https://techcommunity.microsoft.com/t5/Excel/Calculate-simple-equation-which-is-included-in-one-cell/m-p/41382/highlight/true#M235
and that is G&T approach https://techcommunity.microsoft.com/t5/Get-and-Transform-Data/Get-amp-Transform-solving-all-sorts-of-Excel-issues/m-p/46208/highlight/true#M40
