Hi there,

I have a very long table of values that I need to present in a very specific manner as as input file for a program. I need to concatenate the values but it has to include a line break, so that I can later copy (special) the content as text without format.

I was able to do everything, except for the line break...

So the simple question is: When you use "CONCATENATE", can you insert a line break in the resulting expression?


Here is an example:

My data is as follow:

Exemple Excel 001.jpg

And I need to get the following text: (To be effective, I should find two lines in each cell adjacent to the previous table)

AaBa
CbDb
AcBc
CdDd
AeBe
CfDf

Thanks!