VBA Stop cells to cut of text in cell to the left

Hello,

In the file attached is a draft version of a production planning tool. On the left side the orders are displayed, on the right side you can see the work week.
Every order has a certain starting date and time, and in the planning the number of half hours should be colored automatically. So far so good, this works like a charm.

What I now want is that in every yellow order block, the leftmost cell should contain some information about the order, like the product code for example.
I also managed to create this, but unfortunately the cell to the right of this cuts of the text because it contains a formula (I think). But the formula is needed to check if text should be displayed or not.

Who can come up with a solution to let the text just overflow in cells to the right? I can manually delete the formulas in these cells, but it want something automatic.

Thanks a lot in advance!

I don't think you can natively, although it may be possible with VBA - shall I move the thread for you.

I have moved the thread - now in the VBA section.