Inserting Line Break
You can insert a line break in a cell in two ways:
Manually
To do this, type the tilde (~) symbol where the line break should appear. When creating or previewing the file, this symbol will be replaced by a line break. To put a line break in all cells of a column, you will have to manually write the tilde symbol or use Word Form.
Automatic insertion of a line break
If you need to put a line break in all cells of a column on the same principle, you can use the Word Form. There are two functions in it - "Splitting a Name into Components" or "Splitting a String into Parts". The first function allows you to split a cell with a name (only Cyrillic is supported) into parts and save it in the desired format, for example, with a line break after the last name. The second one - to split a cell into parts through any symbol (for example, a space or comma) and also save it with a line break after the first word.