On Sunday, June 19, 2016 at 2:15:27 PM UTC+4, Claus Busch wrote:
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

Hi Claus
THe formula working great
Can you simplify it by ignoring cell A1 and assuming the data is in D1,d2,d3 - get the same result