Excel Question

Where are the strings of text resident? In a text file - either tab delimited or csv?
If you can open the file with excel, you can use a text to column function, probably using fixed width fields to get the data broken into columns and then either sort or filter it to get what you want.

Thank you for your respond. but the text length is not consistent. For example, some invoices is 3-162378 ( which is 8 characters) and some could be 9 or 10 characters (82-182059) or (231-182160-4). That is why I could not use the text to column function to break them out.

You could use a combination of mid, len and if formulas to do this. Below is an example:
=IF(AND(LEN(MID(A26,41,9))=9,MID(A26,50,1)=" "),MID(A26,40,10),MID(A26,40,11))

The above formula would work for invoice numbers that are 10 or 11 characters. Keep adding more if statements to cover the other ones.

Column A Column B
(source) (result)
3 31820-000 JE 502599 Move deposit from 3-162474-2 to 20-176835 3-162474-2
3 31820-000 JE 502718 Move deposit from 82-182059 to 3-162502 82-182059

Hope this helps!