Extracting specific numeric data from cell

[magermaennchen]

Below is the data in one cell ..i want to extract ckt id (113147229) from this which is always more then continous 8 digit number ...no idea in excel how i do ??

A1 : Gi0/3.2351 up up GigabitEthernet0/3.2351 dot1q vlan id=2351. By VPNSC: Job Id# = 4833 : SR Id# = 42034 (113147229\WO_001849\Tata_Motor_CRM_Motor_Sales_NearPatrikaPress_CivilLines_Allahabad_64K\L3VPN-M\COS3)

A:2 : Gi0/3.2352 up up GigabitEthernet0/3.2352 dot1q vlan id=2352. By VPNSC: Job Id# = 4831 : SR Id# = 42033 (113147227/Tata_Motor_CRM_Motor_Sales_MahatmaGandhiMarg_Civil_Lines_Allahabad/L3VPN-M/64K)

pls.help.

[canapone]

Hi, hoping all the numbers you want to extract are delimited by the first "(" and a "/" or "\"

="("&MID(A1,SEARCH("(",A1)+1,SEARCH("\",SUBSTITUTE(A1,"/","\"),SEARCH("(",A1))-SEARCH("(",A1)-1)&")"

Regards

[Marcol]

Try this as a VBa option.

This will extract the first string of 8 or more digits from your string.

If you have leading zeros in your sequence, format column B as text to retain them

Please Login or Register  to view this content.

Hope this helps.

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.