Hi everyone!
I have a small problem of efficiency and I hope you can help.
We get orders for our products in feet and the format is something like this 2' X 3'. Sometimes it is really wild like 7'-6" X 9'-6" (feet)
We have to convert the sizes to cm for our suppliers, so we manually change 2' X 3' to 60 x 90 (cm).
I have a list of the corresponding sizes, so I know that 2'-3" X 10' is supposed to be sent as 70 x 300
I want to make the process of this conversion faster. There are a lot of different sizes, but they are always in a single column, somewhat like so:
| Design | Size | Qty |
| Braided Yellow | 2'-3" X 22' | 20 |
| Interweave Red | 5' X 8' Oval | 10 |
| Vernon Multi | 7' X 7' Square | 5 |
Is there something I can do to automate this text replacement?
Thanks!
