View original (French)

Formula for number of lines in a cell

Solved
MADs -  
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   -
Hello,

I would like to count the number of lines in a cell (characterized by the number of line breaks i.e. ALT Enter)

Let me explain, my cell is the following:

04/10/2016
27/10/2016
21/11/2016
21/12/2016
28/12/2016
12/01/2017

the formula should return the number 6.
Is this possible?
Thank you in advance.

1 réponse

Réponse 1 / 1
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello

this formula for a list in B10 to be adapted
=LEN(B10)-LEN(SUBSTITUTE(B10,CHAR(10),""))

but in your example, if there is no return at the end of the list, it will return 5 (intervals) and not 6

best regards

--
The quality of the answer mainly depends on the clarity of the question, thank you!
3
MADs
 
I will do +1.
Thank you very much.
0
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Not at all, I'm changing the subject
Safe travels
Best regards
0