Originally Posted by
archjake
You can not directly combine text strings. An interesting work around is that you can use a little math to display what you are looking for. By setting an integer value a text string can use a formula to check for a series of numbers with a nested IF statement.
Please see the attached image.
The formula I used is:
if(integer = 1, "Show text string 1", if(integer = 2, "Show text string 2", "ERROR"))
If you wanted additional notes you can keep adding to the nested IF statement.
Hope this helps.