=TRIM(RIGHT(SUBSTITUTE(B5,CHAR(10),REPT(” “;200));200))
Especially useful for project trackers. Add a LEFT(XXX;10) for returning dates.
=TRIM(RIGHT(SUBSTITUTE(B5,CHAR(10),REPT(” “;200));200))
Especially useful for project trackers. Add a LEFT(XXX;10) for returning dates.
