Thank you Adina, that worked!
But what if I need it to display the last xxx characters?
I tried the below value expression as a test. I get the last 2100 characters, but is there a way to get the last xxx characters regardless of the length?
valueexpression=IF(LEN({DE:Multimedia Notes})>140, CONCAT...