Here's how you can add a space after each text value in all the cells in a row:

1. Select the row or column that you want to modify by clicking on the row or column header.
2. Right-click on the selected cells and choose "Format Cells" from the context menu.
3. In the "Format Cells" dialog box, click on the "Alignment" tab.
4. In the "Horizontal" section, select "Left (Indent)" from the drop-down menu.
5. In the "Indent" section, enter the number of spaces or characters that you want to add after each text value in the "Text indent" box.
6. Click "OK" to apply the changes.

Alternatively, you can also use the function to add a space after each text value in a row or column:

1. In an empty cell, enter the formula "=CONCATENATE(A2," ")". This will add a space after the text value in cell A2.
2. Copy the formula to the rest of the cells in the row or column by dragging the fill handle (the small square at the bottom-right corner of the cell) across the cells that you want to modify.
3. The formula will automatically update the cell references for each cell in the row or column.