thanks for your replies all very much appreciated.

with the find and replace, are others apart from 2x10, so it would be a
case of looking for each one in order to do it.

With the text to columns method if i split on the the x then the 2 and
10 would be in different columns.. this could possible work, but would
need a further calculation in the process.

I tried the first method, and this worked perfectly (after realising
the X was case sensitive!)


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