How can I add a space between the excel result to the function =concatenate (Marie, Renard)?

Answer 1

The names should be entered in double quotes and then you can add a third term as a blank with double quotes with a space in between.

Like this: =CONCATENATE("Marie"," ", "Renard")

Alternatively, if using cell references to supply the names, like this: =CONCATENATE(A1," ", A2)

The same approach can be used to insert a comma between last and first names, for example:

=CONCATENATE(A2,", ", A1)

I hope that helps!