CodePudding user response:

To make the code yourself

CodePudding user response:

Don't think I capture effect is feasible?
B4 cell formula:=the IF (C4=""," ", ((DAY (C4)) & amp; CHAR (10) & amp;" "Zhou & amp; (WEEKDAY (C4, 2))))

CodePudding user response:

refer to the second floor Smile_unix response:

Don't think I capture effect is feasible?
B4 cell formula:=the IF (C4=""," ", ((DAY (C4)) & amp; CHAR (10) & amp;" "Zhou & amp; (WEEKDAY (C4, 2))))

B4 cell is that, "Monday, 19"

CodePudding user response:

Impression of the cell is can't use the formula of merger, suggest you first do not merge cells, such as this formula after the completion of the merger cell again,