Forum Discussion
Excel Table formatting
I'm stuck, is there a formula i use that will add multiple lines in a column ?
Or, if you mean it has a line break in a single cell: =SUM(--TEXTSPLIT(A1,CHAR(10)))
- CHAR(10) = line break character
- TEXTSPLIT() splits the cell into an array. An example might be [10|20] but the pipe is the line break
- "--" converts the array text to numbers