I want to add a space (or any character(s)) after each text value in all the
cells in a row or in a column

For example, cell A2 contains "ABC", cell B2 contains "DEF", and so on. I
want to make all the cells in row 2 to have a space so cell A2 contains "ABC
", cell B2 contains "DEF ",...