concatenating strings in shapesheet

[david]

how can i concatenate strings in shapesheet? there's no such function "concatenate" and i didn't find any similar function.

anyone knows?

[Michael Dag]

use &               =Sheet.1!Prop.Text1&" My Text 123 "&Sheet.1!Prop.Text2

is a valid shapesheet formula (if Prop.Text1 and Prop.Text2 are present  )

[david]

thanks.
it worked .