How to extract

[ahovander1213]

Need a formula or macro to extract specific info

Below in bold is what I am pasting into Excel as 1 column, 4 rows
I don't care about row 1

I can use LEFT function to get the 1st 6 digits.

My issue is how to I get middle (example 2,405.66 in row 2). My issue is there is no consistency.
/1 has various blank cells before it gets to amount i want. After amount I also get various blank cells.

In my example I have underlined the data I want to extract.


PO #/Line Rel # Amount Paid Qty Received
505979/1 2,405.662.00
505979/2 1,271.68 1.00
506339/1 2,405.66 2.00

 

[jtakw]

The number of spaces vary (click "Reply With Quote" to see the OP's actual layout).

Just checked, and that's what I figured, so my formula in Post # 7 should work fine, unless those might be "Non-breaking spaces".