Line break with a concatenate

The last one & should I put it too?

Sorry, I tried with and without: with it gives an error ^^ and without it gives me the same result as when I put chr(10)

Best regards

Thank you :) I understood the & but if you don't put anything after it, it can't work :/ in any case, it doesn't work for me ^^"
Best regards

What I want is to concatenate in one cell, the filled cells from the selected range. The data is then grouped in one cell separated by a "";"". That was perfect ^^.
However, I was asked for the data to be separated by a line break, like this:

topic1
topic2
topic3
all of this in one cell ^^.

I don’t know if I was clear, let me know if you didn’t understand :)
Best regards

instead of: topic1; topic2; topic3

And normally there is a 3 after the last "Topic"

Hello,

via55 has already suggested this idea but it's not working for me (CHAR(10)=Chr(10) ) I believe ^^".

Best regards

whether you use CHAR in a formula or CHR in a function, it's the formatting of the cell receiving the result that I was talking about.
This formatting is essential when using CHAR(10) in a formula, is not required when using chr(10) in a macro, but in a custom function, I don't know.
But well, you probably tried;
best regards

Ah, formatting! Sorry, I misunderstood ^^" I've already formatted the concerned cell (as you and Mike told me) and it gives the result above with this macro:

Function Concatener1(Plage As Range) As String
Dim C As Range
Dim Texte As String
For Each C In Plage
If C <> "" Then
Texte = Texte & vbCrLf & C.Value
End If
Next C
If Len(Texte) > 0 Then Concatener1 = Left(Texte, Len(Texte) - 2)
End Function


But it eliminates half of the last value and there is a space between the top of the cell and the first data.

... actually, it seems to work correctly if we remove & vbCrlf
that is:
Text = Text & C.Value & chr(10)
that's all I can say
good luck
best regards

Oh yeah ^^ thank you very much!!! ^^

Best regards

Thank you very much! ;)