Hi,

Am Sun, 19 Jun 2016 12:01:51 +0200 schrieb Claus Busch:

for only one string in D1 use in E1:
=TRIM(MID(SUBSTITUTE(D$1," ",REPT(" ",99)),ROW(D1)*99-98,99))

and copy down


Regards
Claus B.
--
Windows10
Office 2016