I have the following text in a cell:
DURA-SKRIM R12BV (38 lbs/msf)
I need to extract the number 38 from the cell and use as the divisor of 10,000 then multiply the result by 1000 round that result to the nearest 5K and populate in a separate cell. So for example the output I would be looking for in this example would be 265,000. I will need to replicate this formula in other cells that will have the same format but differing numbers of characters for example:
DuraSkrim J25DT1 Textured 1-Side (115 lbs/msf)
In this case I would want to extract the number 115 from the cell and perform the same operation
Thanks in advance for your assistance.
Bookmarks