K
K
kamwork2016-05-14 12:21:08
Google
kamwork, 2016-05-14 12:21:08

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

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 the question

In order to leave comments, you need to log in

1 answer(s)
A
arti_shock, 2016-10-22
@kamwork

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question