True, this can be done, but the information from the cell will be scrabled
sometimes, this is one way that I tried but it left some characters in the
cells with the number. Thanks for the response.
--
Thomas


"David Biddulph" wrote:

"T Miller" wrote in message
...
Alright, if I have this in a cell

2000 PK/TH/5000 EA/PK

and I want to multiple the first number (2000) * (5000) to get to
10,000,000
in the cell as the answer. What is the best way to set up this if
statement?
The actual number may be smaller but the max would be a fpur digit number.
Any help would be appreciated.

Data/ Text to Columns/ Delimited/ by space & by slant character.

then you can multiply the relevant elements.
--
David Biddulph