Solved: Line Breaks?

[jacqelynl]

:help Is there a way to break a trim expression with 3 fields so that each field in the resulting data appears on a different line.:banghead:

=Trim([activityname1] & [workername1] & [note1])

What I want the results to be is:

Swimming
MaryLou
This is a note

If this is not possible, can it be done in VBA? I am not a VBA expert.

Thanks for your help!

[JimmyTheHand]

Hi :hi: and Welcome to VBAX!

You may want something like this,
=Trim([activityname1] & vbCr & [workername1] & vbCr & [note1])
where vbCr is a Visual Basic constant for Carriage Return character.

Jimmy

[jacqelynl]

As I said - I'm not familiar with the VBA codes. Didn't know what to look for. Thank you so much!