Wrapped text for HTML in excel cell

[Rhothgar]

Hi

Happy New Year to all! Hope you are all keeping well and had a great break.

I'm working on a spreadsheet and cannot find out how to do this.

The text in the cell is HTML format and it reads as such.

I tried Format Painter but cannot replicate it in another cell.

How is this possible please?

EDIT:-

I've just now copy and pasted another cell into Notepad ++ and don't it manually but that would be way too tedious for the purposes I need.

I had a dabble with PowerQuery of the Xmas break. That's absolutely amazing. I dare say it could probably be done in there relatively easy.

Photo is what I want.

 

[RoryA]

You need to add line feeds (Alt+Enter) at the points at which you want a new line.

 

[Rhothgar]

You need to add line feeds (Alt+Enter) at the points at which you want a new line.

Thank you.

That's useful to know.

It won't be happening on this spreadsheet. I'll maybe attempt to powerquery it into some logic.

 

[Rhothgar]

Thanks for your assistance yesterday on this.

Actually, I've had to start doing some amendments to the sheet and I've run into another issue linked with this.

So when I've edited a cell out using Alt+Enter, to minimise it, I've formatted the cell to uncheck Wrap Text and this minimises the row to the standard 15 high or whatever it is.

When I hit F2 to re-enter the cell, it rechecks Wrap Text so on hitting Enter to move to next cell, the previous cell remains 300 high or whatever the height it and I have to go in and uncheck wrap text again.

Any ideas how this can be set?