Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 11, 2020 11:04 PM
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!
May 11, 2020 11:25 PM
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}
May 11, 2020 11:42 PM
Thanks so much, it worked!