Formula to extract certain texts
 

Good day.I need help to extract certain texts in column A to place to columns B,C and D as in the attached file. Those are the ID, azimuth and distance generated by CAD lisp. I did the first three manually but i see a formula in columns B,C and D does best. Thank you ExcelBanter

Formula to extract certain texts
 

Hi,

Am Tue, 7 Feb 2017 15:19:20 +0000 schrieb ecdlc888:

Good day.I need help to extract certain texts in column A to place to
columns B,C and D as in the attached file. Those are the ID, azimuth and
distance generated by CAD lisp. I did the first three manually but i see
a formula in columns B,C and D does best. Thank you ExcelBanter

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)-12),"")

and copy the formulas down.


Regards
Claus B.
--
Windows10
Office 2016

Formula to extract certain texts
 

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