How to wrap to the next line in place of a space in cells?

Question

excel

There are links in the cells of the document.
There are several of them in each cell . It is

necessary to wrap to the next line at the place of the space that separates the links
. How to do this?

There are a lot of cell links, you need a way to automate this process

OR

How can you chain data from different cells into one line so that information from each cell has a transfer to a new line?

Answer 1

Search and replace
in the "Find" field, put a space
in the "Replace with" field, press Ctrl + Shift + J
Replace All
ALL spaces will be replaced. The rows will need to be increased in height, otherwise only the first row in the cell will remain visible.
But in general, this is not entirely correct, from the point of view of data organization, it is better to scatter links on separate lines so that there is one address in one cell.

Answer 2

When editing a cell, press alt enter