Need to extract particular details from entire column

hi Prakesh. to help you, we need to identify patterns. 1 example does not help much. so my assumption here is the invoice number is always a space after that text & is a standard 8 numbers:
=MID(A2,FIND("Invoice No. ",A2)+12,8)

or in between "Invoice No." & " dt. ":
=MID(A2,FIND("Invoice No. ",A2)+12,FIND(" dt. ",A2)-FIND("Invoice No. ",A2))

if you need the text "Invoice No.", then:
=MID(A2,FIND("Invoice No. ",A2),20)

or:
=MID(A2,FIND("Invoice No. ",A2),FIND(" dt. ",A2)-FIND("Invoice No. ",A2))