Ron - can you explain how to start with the steps you recommend. I don't see where to select delimited from the Excel main menu as noted. The data I need to truncate is already pasted into a column so I don't need to import the data.

Thanks,

Tony

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com