=TRIM(RIGHT(SUBSTITUTE(B5,CHAR(10),REPT(” “;200));200))

Especially useful for project trackers. Add a LEFT(XXX;10) for returning dates.