Need Help...Extracting variables from pdf invoice extracted to excel.

So I have pdf invoices (500+ pages) that have been extracted to excel. I need to pull the subtotals from the excel version to add up. The issue is that the totals are in different locations of the excel cells. Some are in the beginning of the cell and some are at the end.

I've attached example data and the corresponding results I'd like to get. This is well above my head and I'd really appreciate your help if possible.

Thanks a ton,

Brian

It is difficult to generalise from only two examples, but it looks like you have 6 space characters after **Total** before the number in the format nnn.nn

Another consideration is that the asterisk can be used as a wildcard character, so in the following formula I have changed two asterisks to a pipe character. I've also assumed that you would want the totals as numbers, and if that is the case you can put this formula in B6:

=IF(ISNUMBER(SEARCH("|Total|",SUBSTITUTE(A6,"**","|"))),MID(SUBSTITUTE(A6,"**","|"),SEARCH("|Total|",SUBSTITUTE(A6,"**","|"))+7,12)*1,0)

and then copy down.

Hope this helps.

Pete

Thanks a lot for the reply...Pete_UK's response worked perfect, but I'm sure the others would have too. This save my team 50+ hours this week.