Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
|
|||
|
|||
Quote:
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extract formula result form cell without running formula again | Excel Programming | |||
extract formula result form cell without running formula again | Excel Programming | |||
Counting texts | Excel Discussion (Misc queries) | |||
Extract texts & numbers from one cell into four cells | Excel Discussion (Misc queries) | |||
extract a foldername with a formula-update formula does not work | Excel Programming |