HockeyDiablo
Board Regular
- Joined
- Apr 1, 2016
- Messages
- 182
A | |
1 | 10 yr spring 399 rollers 188 sc 40 total 627 ck |
2 | sc $40 radio board $140 spring $103.80 total $283.80 ck |
3 | same day 5 yr 299 cables 58 rollers 148 sc 40 545 |
<tbody>
</tbody>
Above are a few samples strings from Microsoft Excel that I need the extraction from, respectively in cells "A1", "A2", "A3"...
I have several items in the string and need to extract the pricing, but it could be to the left or the right and wont always carry a $ sign.
Example: I would like to select "sc" as the defined criteria and return the first numerical value to the left and right
Return: something like this
B | |
1 | 188, 40 |
2 | , 40 |
3 | 148, 40 |
<tbody>
</tbody>
I could work with values in "B" and "C"
Last edited: