Use delimiters for breaking text into columns in Excel
Microsoft Excel text 2 Columns Menu
Lets say you have a line which you had copied from somehwere and contains data like First Name, Second Name and City. Now once you put it in excel and you want to seperate out in diff columns , this will be a difficult job, Specially when you have lets say 300 lines of such data.
Its time you should know Columns to Text Feature of Micrsoft Office Excel 2007. This helps you to break along text into columns of excel based on certain de-limiters. Most of the time you will have just on delimiter in these cases. You can save a lot of time doing this.
Converting Text 2 columns in MS office 2007 Excel
The menu is availble under Data Tab of the ribbon menu.
Posted on 28th October 2008 by Ashish Mohta , A Professional Tech blogger, Editor and Writer who talks about solving day to day problems of people who use computer. He also writes on How to use the applications like Office, PC tips, Online tools,Browsers and more. All posts by Ashish Mohta | Connect with me @ Twitter | Linkedin | Facebook | Stumble
Sign up for our daily email newsletter
Leave your response!