Hi All,

Am Sun, 19 Jun 2016 06:06:56 -0400 schrieb GS:

This creates a column of results where OP requests same row starting in
E.

sorry, my bad
Try in E1:
=TRIM(MID(SUBSTITUTE($D1," ",REPT(" ",99)),COLUMN(A1)*99-98,99))
and copy to the right and down


Regards
Claus B.
--
Windows10
Office 2016