I have a spreadsheet which has a weight column. This is exported as
25kg, 1000kg, 10x2kg from another program.

I am trying to use this weight column in a calculation. I have
inserted a new column and copied the information over and then used the
find/replace to remove the KG to use in the calc cell. This works fine
for the 25 / 1000 etc, but the 10x2 will not caculate.

Is there a way that when i paste the cells that i can get it to change
to 20 automatically. ( i presume that the x will need to be a * ?)

thanks.


--
mdma
------------------------------------------------------------------------
mdma's Profile: http://www.excelforum.com/member.php...o&userid=24284
View this thread: http://www.excelforum.com/showthread...hreadid=378934