I think you can do it by selecting

DATA
Text to columns
Fixed width

this will help only if its allways the 4th number in the cell


--
shlomop
------------------------------------------------------------------------
shlomop's Profile: http://www.excelforum.com/member.php...fo&userid=9734
View this thread: http://www.excelforum.com/showthread...hreadid=535297