I have a column which contains the following type information
2100 X 750
What I want to convert this into is two columns -
the first which would pick up only the 2100
the second which would pick up only the 750
I would then create a third column which would multiply the two.
Does anyone know how I can create the 1st and 2nd columns using a formula?
Bookmarks