Help

Unable to add space to formula

Topic Labels: Formulas
Solved
Jump to Solution
1701 2
cancel
Showing results for 
Search instead for 
Did you mean: 
GRF_Admin
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Nick_Dennis
7 - App Architect
7 - App Architect

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.

See Solution in Thread

2 Replies 2
Nick_Dennis
7 - App Architect
7 - App Architect

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.

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!