Split cell into 2 lines

[Windcheetah]

Hi, I’ve got a cell with a month in it, and would like to have the month on 1 line, and on the line below, in the same cell, have the year. So it ends up something like:

January
2024

What I think I need is a line break after the month??

I’ve tried wrap text, but that’s not what I really want, as I want it to be on all the cells, not just the ones with larger month names.

Thanks
Martin

[Zizi64]

If you want strings in the cells (but not numeric Date values), then you can use a concatenate function:

="january"&char(10)&"2024"
or:
=CONCATENATE("january";char(10);"2024")

[JohnSUN]

… or =TEXT(DATE(2024;3;25);"MMMM"&CHAR(10)&"YYYY")