ahovander1213
New Member
- Joined
- Oct 13, 2018
- Messages
- 10
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
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