How to replace spaces inside a cell in Google Sheets with another character?

Question

Google

There is a column with data, I need to make a similar column next to it, where the problems will be replaced by another given character. How can this be done in Google Sheets?

Answer 1

В ячейки B1
=SUBSTITUTE(A1;" ";"_")
во второй секции вводим символ который нужно заменить, а в третей символ для замены