using formula - extract text separated by 2 spaces
On Sunday, June 19, 2016 at 2:02:41 PM UTC+4, Claus Busch wrote:
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
Dear Claus
Sorry to bother again - but can you give me the vba code which would get the same result as the above formula if all data are in column D
thxs
|