- Highlight the column.
- Choose Text To Columns from the Data menu.
- When Excel opens the Text To Columns wizard, click Finish.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.