HockeyDiablo
Board Regular
- Joined
- Apr 1, 2016
- Messages
- 182
I am trying to extract random pricing data within a string. I have about 50 set prices for items within the string. Wondering if one of you excel geniuses on here can think of an easy solution? Here is the method I have came up with. Any ideas are welcome.
<tbody>
</tbody>
A | B | C | D | E |
Description | Left 10 Chars | Number Extracted | Right 10 Chars | |
1 | Steel White $599 Sears Craftsman Trolley 22 198 galv rollers Total $815 | eel White | 599 | Sears Cra |
2 | 5 yr Sp $130.00 cables 38 Keyless entry FREE LM Belt Drive 10yr War. $349.00 517 Total on CC | 5 yr Sp $ | 130 | cables 38 |
<tbody>
</tbody>
Last edited: