Insert Space in Concatenate Formula

Hi, im trying to insert a space into a concatenate formula in the primary field of my table. ive seen some similar posts, but the answers dont seem to be working for me. my formula is:

CONCATENATE({First Name}, {" "}, {Middle Name}, {Last Name})

{" "} is where i want the space.

Any help is appreciated!

Remove the curly brackets. Those are only used to surround field names that have spaces in their names (although they can be used for any field names).

Also, you don’t even need to use the CONCATENATE command… you can just use the & sign like this:

{First Name} & " " & {Middle Name} & {Last Name}

Thanks so much, it worked!

2 Likes