How to Replace Text in One Column Completely?

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 ...