Excel how to add a hyperlink to concatenate

I have created a function, which creates a template e-mail based on a few different cells. The formula is like CONCAT(cell1; CHAR(10); cell(2); HYPERLINK("https://google.com","Click here"); cell3; CHAR(10); HYPERLINK("https://youtube.com";"Youtube")). Problem is, excel does not include the hyperlinks, only the texts. How can I do that? I also tried creating 2 different columns, one with the urls and one with the texts and creating the hyperlinks this way but to no avail. How can I fix that?