Is it possible to have Excel wrap text that overflows across multiple columns?

I can attach a screenshot but what I'm asking is this:

Say columns B through whatever are very tiny (0.5 width).

Say column B1 has text that goes through a lot of these thin columns, maybe to column BM.

So since only B1 has text Excel will overflow the text and you will be able to see all of the text.

But say we put text in BI1 so that the text in column B1 is cut off at BI1. The result is that the text starting at B1 is cut off where the new text begins.

My question is, is it possible (via any option or even a macro) to have a wide row and wrap the text so that you can see all of it?

Does that make sense?

Screenshot. The text starts at B1, but then I start new text later with the word "here". So the B1 text gets cut off. Is there any way to see all of the text in B1 hopefully by wrapping it?

Thanks!