How to set fixed cell height in spreadsheets?

Question

Google Sheets

Problem: with an increase in the number of lines (that is, not with an increase in the number of letters in one line, this is solved by trimming the transfer) in the cell, its height increases. How to fix it?

Answer 1

No way. Multiline cells will be displayed by the height of the number of rows in them.

Answer 2

Use multi-line data as an argument for a function that selects only the data you need (you don't always need everything) Also
, there are great functions:
MID
SPLIT
SUBSTITUTE
And best of all, the combination TRANSPOSE(SPLIT( ) )
Made all the options in your plate.
I propose to leave it for posterity, goo.gl/v5tM5N