how do you have set that field,being plain text or RTF?

try to insert text there manually (eg in QuickEdit) and investigate how is it stored. then make your updates based on that.

Thanks for responding Marian. I have it set at Rich Text.  Maybe it should be plain text?   Was looking at manually editing but wondering how I'd even throw in the right combination of characters...further investigation..

plain/rtf - depend on your needs

for rtf formatting - SP internally stores it in HTML format, so you may need to do something like this

Hi Troy,

Try adding the '{Common:NewLine}' in 'Build String' action and then add your variable to the field. It has worked for me in past.

Please share your solution.

Hope this helps!

Mandeep

HI all,

Marian set me off in the right direction .  I ended up putting in <BR>'s which worked within SharePoint.  Common: Newline didn't work in any scenario (using it in a build string, or directly in the Create Item action). 

However, the whole purpose of putting in the Newline is so that it looks "pretty" when we export the data to Excel for manipulation.  So it now looks great in a  SharePoint list, but when exported to excel, the <BR>'s don't translate.  Just FYI for anyone trying to do this in the future.   But this is something I'll look into..might have to throw in  <P> or something like that.

Thanks all for your input!

Cheers,

Troy

Hi Troy

Did you work out how to export to excel without the <BR>s? 

Jo