How do I insert a blank in a concatenation formula?
Solved
Inserted a blank in a concatenation formula
Best answer by Jason11
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.
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
+20Dear 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.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.