Is is possible to concatenate "Comments" standard (long text) field?

[Carol_]

I am creating a formula field to concatenate 2 fields from activities. One of the fields is the "comments" field that is available as the only long text field from activities. However, I cannot find the "comments" field when searching for it to include in my formula. I tried a workflow rule with field update, but the problem is that I cannot create a long text field withing activities to hold the information from "comments" and then concatenate it with another field.

Any help? Thanks!!! 

[Shailesh]

No, you cant do that. The reason I believe is that a formula field can return text, number, date, datetime, percent fields. So when you try to assign a value from Text area long it may possibly contain carriage returns in it where as yur normal text field is just a single line field.

Also the length of text area long is greater than normal text field.

Here's the link to the Idea. Vote for it:

http://success.salesforce.com/ideaview?id=08730000000BrhEAAS

[Carol_]

Ok. Is there an Apex alternative?

[Shailesh]

Yes you can do it using apex.

[Carol_]

How does that work? Should I ask someone to help me?

[Shailesh]

You will need to create a trigger on task for this purpose. also make sure, the field in which you need to copy the concatenated value is a text area long field, and the concatenated value is less than 32768 characters.

[Carol_]

Yes, the Apex trigger is probably too advanced for me.. thanks for your help though.