Jan 06, 2021 04:04 AM
When trying to do the very simple formula of
CONCATENATE({First Name}& “ “&{Last Name})
it won’t submit, simply saying invalid formula. I have read another thread that said this is what to input to have a space between the two values, and that I also shouldn’t need to use the concatenate prefix, I’ve tried many things and nothing works. Any help?
Solved! Go to Solution.
Jan 06, 2021 04:23 AM
You don’t actually need CONCATENATE here, although you could use it with commas instead of &'s separating the parts of the string you want to combine.
But a simple {First Name} & " " & {Last Name}
should do the trick here. Make sure that the quotation marks are plain text and not formatted as well. Hope that helps.
Jan 06, 2021 04:23 AM
You don’t actually need CONCATENATE here, although you could use it with commas instead of &'s separating the parts of the string you want to combine.
But a simple {First Name} & " " & {Last Name}
should do the trick here. Make sure that the quotation marks are plain text and not formatted as well. Hope that helps.
Jan 06, 2021 04:33 AM
Ah, it was the quotation marks being plain text!! Not too sure how to do that, but I copied and pasted what you put and it works! Thank you!