|
|
|
|
Quote:
Originally Posted by Claus Busch
Hi,
Am Tue, 7 Feb 2017 17:30:45 +0100 schrieb Claus Busch:
try in B1:
=IF(LEFT(A1,5)="Sshot",--MID(A1,FIND("<",A1)+1,FIND("",A1)-FIND("<",A1)-1),"")
in C1:
=IF(LEFT(A2,5)="Sshot",MID(A2,FIND("=",A2)+2,FIND( """",A2)-FIND("=",A2)-1),"")
and in D1:
=IF(LEFT(A2,5)="Sshot",--MID(A2,FIND("Distance",A2)+12,FIND("#",SUBSTITUTE( A2,".","#",2))-FIND("Distance",A2)-8),"")
have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYo_mMuWeih71CaoXQ
Regards
Claus B.
--
Windows10
Office 2016 |
Hello Claus,
That works very very good.
Thank you and regards,
ecdlc
But wait, when i copy-drag the formula at distance column, the distances decimal point disappear
Last edited by ecdlc888 : February 8th 17 at 05:15 AM
Reason: add remark
|