You might try using this expression: Substitute ( List ( Field1 ; field2 ; field3 ; // and so forth ) ; ¶ ; " " )
List will automatically drop out empty fields and then the substitute function replaces the returns with spaces.
You are a legend. I don't pretend to understand why this works but it did the job a treat. Many thanks.