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!
+35Remove 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}
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!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.