Want to Extract Data from same line in Excel

[carefh]

Hi, please help to extract the data from single / multiple line statement in Excel. I have to extract number from my excel data sheet which has more then 6000 rows.

My question is, how to extract this stirng ;977______________;

Here, i have to extract data like first 4 character matching ;977 and ending match ; semicolon and i have to extract data between that. By selecting 4 starting character ;977 and ending after 10th character with semicolon ; from this data.

For example : i have this data in single line and i have to extract that highlighted data text in Red Color. How to do that? Please help me with any formula or tips.

200515257081258;Normal;;200515257081258;CARDHOLDER;101404733_NP-1022194621;2019-08-27 16:52:25;2019-09-08 10:40:02;200515256881258;No;Subash Basnet Kaji;;;Subash;baluwatar;;Bagmati;Kathmandu Metro 3 - Baluwatar Area;Baluwatar;9779841903209;;Kathmandu Metro 3 - Baluwatar Area;;Nepal;;Subash;baluwatar;;Bagmati;Kathmandu Metro 3 - Baluwatar Area;Baluwatar;9779841903209;;Kathmandu Metro 3 - Baluwatar Area;;Nepal;COD;299.00;299.00;50.00;;Debit / Credit ATM Card Holder Fashionable Fiber Case (Multicolour);Color Family:Multicolor;;NP-Aramex-Fleet;Dropshipping;standard;;44828212656;;;;;;No;Shipped Back-Success;cancellation-failed Delivery;Delivery address is wrong;;;;;

 

[FormR]

Hi, with your string in cell A1 - you could try this.

=MID(A1,SEARCH(";977??????????;",A1),15)