one possible solution
See attached; basically simply adding three new columns with formulas that give you what I think you want. If you want to replace the original columns, then you could do a copy>paste special>values on the three new columns and delete the original three columns.
|