Merge cells: concatenate 2 cells to form one text string

Hi, I need a quick formula.

How do I merge the attached cells to read the highlighted cell?

Many Thanks

Your thread title is poor, as merging cells is not what you are asking about. What you have described in your post and shown in the workbook is concatenation.

Try this:

=C4&" "&TEXT(C2,"dd mmmm yyyy")

I have edited your thread title this time: take more care and be more descriptive in future, please.

That's not what you showed in your workbook - in future, please state everything you want at the outset.

You could try this:

=C4&" "&TEXT(C2,"dd")&LOOKUP(--TEXT(C2,"dd"),{1,2,3,4,21,22,23,24,31},{"st","nd","rd","th","st","nd","rd","th","st"})&" "&TEXT(C2, "mmmm yyyy")