sorry if i am Wrong!
But I think, i use to from VBA:
go to data/text to columns and press finish
and in my work use to work, but I haven't use it long time ago

--
Message posted from http://www.ExcelForum.com