Assign flow of text

[dareeldill]

I am recreating an existing form that is usually filled out by hand. One specific text field has a second text field on the lower right corner. Therefore the text that goes in the larger field needs to flow around the smaller field.

The goal is to do this with no VBA coding. I also don't want users to have to click on multiple fields, the text should flow without flowing into the smaller field.

I have included an example of how I'd like the text to flow.

Thanks in advance for your help.

[6StringJazzer]

It would be helpful to illustrate this with actual text. Is this just a rough mockup to show the idea of the layout, or are you really using individual cells as shown?

The short answer is that Excel cannot do this. Excel is a computational tool and doesn't do text layout, such as flowing text. To complicate matters, Excel cannot treat multiple cells as though they were a single block of text, as what your example seems to intend.

If you are not using Excel formulas, and just using this as a way to replicate form, you would be better off using Word for this. Please see example attached.

[dareeldill]

Ideally it will not be multiple individual cells. It would be one block. Normally I'd merge the cells, but since its not a regular rectangular block of cells, I couldn't do that.

I know I'm pushing the capabilities of what excel can do, but if I could figure out a method of doing this, this sheet will go with several other related sheets that are already built into Excel.

You're example is fantastic. You understand exactly what I'm trying to do. Too bad I can't easily recreate the effect in Excel.