Question

How to add space in excel between names

Answer 1

To add space between names in Excel, you can use the CONCATENATE function or the ampersand operator (&).

Step-by-step explanation:

To add space between names in Excel, you can use the CONCATENATE function. Here is an example:

1. Assuming the names are in column A, in an adjacent column (let's say column B), type the formula '=CONCATENATE(A1, " ", A2)'. This will join the names in cells A1 and A2 with a space in between.
2. Drag the formula down to apply it to all the names you want to add spaces to.

This will create a new column with the names having spaces in between. Alternatively, you can use the ampersand (&) instead of CONCATENATE function like '=A1 & " " & A2'. This achieves the same result. Remember to adjust the cell references accordingly.