Share via

TEXTJOIN return format

Anonymous
2023-11-06T20:31:20+00:00

I currently have the following formula to create a birthday calendar from a set of data

=TEXTJOIN(", ",TRUE,IF(G11=$AA$2:$AD$386,$Z$2:$Z$386,""))

Currently, if there are two birthdays on the same day, it returns this to the cell:

Sue Codd's Birthday (1956), <br>George Hocking's Birthday (1937)

I want it to return with a break in the results as such

Sue Codd's Birthday (1956), <br> <br>George Hocking's Birthday (1937)

Is it a character thing I need to add to the formula?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-06T22:15:20+00:00

    Hi James

    Is it a character thing I need to add to the formula?

    YES

    Try the formula

    =TEXTJOIN(", "&CHAR(10),TRUE,IF(G11=$AA$2:$AD$386,$Z$2:$Z$386,""))

    Make sure cells are formatted Wrap text

    Regards

    Jeovany

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-11-09T02:43:03+00:00

    Thanks Jeovany. It worked

    Regards

    James

    Hi James

    Is it a character thing I need to add to the formula?

    YES

    Try the formula

    =TEXTJOIN(", "&CHAR(10),TRUE,IF(G11=$AA$2:$AD$386,$Z$2:$Z$386,""))

    Make sure cells are formatted Wrap text

    Regards

    Jeovany

    Image

    Was this answer helpful?

    0 comments