I have an existing formula field which produces a number of text values based on different criteria. I am now creating a new formula field that looks at the first field to produce a reduced set of values.

The problem I have encountered is that two of the values in the first formula field contain an ampersand - & - and my new formula field does not seem to see those values, and so is ignoring them when producing the output values.

eg.

This

That

This & That

My formula

Do I need to somehow escape the ampersand to make it find them in my other field? I have tried different ways I could think of:

The problem I have encountered is that two of the values in the first formula field contain an ampersand - & - and my new formula field does not seem to see those values, and so is ignoring them when producing the output values.

eg.

This

That

This & That

My formula

If([ex field] = "This", "One", [ex field] = "That", "Two", [ex field] = "This & That", "Three")However my output gives me a "One" and a "Two" but for the values that should be "Three" it just shows as "<empty>"

Do I need to somehow escape the ampersand to make it find them in my other field? I have tried different ways I could think of:

If([ex field] = "This \& That", "Three")Is there something else I need to use to make my formula work? Unfortunately it is too late to go back to the other field to replace the & with an "and"

If([ex field] = "This && That", "Three")

If([ex field] = "This & That", "Three")

Mike

Thank you