DEF Highligh the column then go to "DATA" then "Text to Column". You will have 2 choices, Delimited or Fixed. I don't know how the data is so I am guessing no commas. I would choose Delimited. Click next. Click tab as I think there is no spaces. If so then click spaces too. click next then the data should be highlighted. In the column data format click "Text". Then finish. That should solve it. Johnny
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel