Cancatenate values on one cell on descending order

I will appreciate if someone may can help me to figure out if is possible to have multiple concatenated values in one cell
on descending order instead of to the side and wrap
Eg, January, February, March, April

I will like to concatenated values in one cell to show like this below
January
February
March
April
and so on

Thanks in advance to anyone who may have a solution for this, thanks very much.

If you're using a formula then use CHAR(10) as your delimiter.
If you're using vba then use vbCrLf as your delimiter.

Hi jason.b75, thanks for your response Im. using a UDF code with array formula to retrieve the desire values on the array i identify each desire values with the asterisk ***
see code below and array underneath, thanks for taking a look, may you can help me with this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

It would be easier to just enter the character into the formula.

I've not used that code before but I'm going to assume that it works the same way as Harlan Grove's Aconcat function, here's a short example formula using an extract from your huge formula in the previous post.

=StringConcat("",IF('Men Rank Placement Record'!$C$5:$C$42='Men''s Pics Profile'!$E$3,'Men Rank Placement Record'!$F$5:$F$42&CHAR(10),""))

Note that I've used a null string for the separator and joined the line feed CHAR(10) to the end of the 'value if true' part of the IF function.

You will need to apply the 'Wrap text' format to the cells with the formula for it to work.

Thank you very much, this solved my thread , but instead i had to use CHAR(13) for MAC, cheers!