Do you mean a single blank space? If so you can just use " ".

i.e.

string1 & " " & string2

Dear Sir,

Thank you for your answer to Gary_Nelson’s question about adding a single blank space into a concatenation formula.

I cannot apply your to my formula.

I have three fields I am Concatenating: Village, Municipality and Department

I’d like to put a space in between each. Here’s the formula I have and it works but without spaces:

CONCATENATE({Aldea}, {Municipio}, {Departmento})

What would you add to this formula so that a blank space would appear between each name?

Thanks

Rob

Hi @Rob_Cahill,

You can adjust your formula to CONCATENATE({Aldea}," ",{Municipio}," ",{Departmento}) to include spaces between each referenced field.