Try this modification of Jeff's formula

=--TRIM(RIGHT(SUBSTITUTE(TRIM(Q24)," ",REPT(" ",100)),100))