Errors creating a formula

Errors creating a formula

I'm trying to create a formula on a Form that concatenates two text fields for use as a lookup in another form.

When I create the formula:

Episode_Name + " " + Episode_Number

I get the below error. I've tried this on multiple forms with different fields - all with the same result. What am I doing wrong??




-------------------------
Encountered "" at line 1, column 0.
Was expecting one of:
"!" ...
"+" ...
"-" ...
"count" ...
"empty" ...
"exists" ...
"groupCount" ...
"(" ...
"{" ...
...
...
...
...
...
...
...
...
...
"TRUE" ...
"FALSE" ...
"null" ...
...
"input" ...
"this" ...
"list" ...
...
-------------------------------