Concatenated text field in automation

[Nick_Kerzman]

My goal is to have a formula to populate New Profile from either Legacy Profile or a Concatenate of Company Responsibility, Professional Background, Educational Background. Ideally for the Concatenate portion, I can have the three fields with a paragraph break between them, if that level of formatting can be achieved. (as demonstrated in the sample table below)

My records will only have either the legacy field or the new 3-field combo populated with data.

New Profile fx	Legacy Profile	Company Responsbility	Professional Background	Educational Background
Amazing legacy profile	Amazing legacy profile
CEO responsible for big things.Worked at great companies like…Super smart because they went to the University of Smartness.		CEO responsible for big things.	Worked at great companies like…	Super smart because they went to the University of Smartness.

Thanks for the assistance.

[AlliAlosa]

Hi there!

Try this :slightly_smiling_face:

IF({Legacy Profile}, {Legacy Profile}, {Company Responsibility} & " " & {Professional Background} & " " & {Educational Background})

Hope that helps!