Videos | Books | What's New | FAQ | Testimonials | Buy Credits | Support | Login | My Account

Splitting Text Without Equations Added to Library on 11 Feb 2007 Length: 6 mins View Tutorial Movie Download File Used This movie shows how you can manipulate data in Excel to get it in the format you need. This tutorial ONLY uses features in Excel and does require any equations. The tutorial takes a list of US presidents and orders them according to the number of years they had in office. The list is initially in the format "1789-1797 Washington". Related Tutorials: Splitting Text Strings Using Equations Feedback for this tutorial: "The tutorial was very informative.I did not know that this feature was available! It will be a real time saver when it comes to splitting up lists of data. I am anxious to give it a try. Thanks, Kay" "Brilliant simple tool for splitting text. Very beneficial for me." "I do come across situations where I need to split text in data given to me by my colleagues. I don't know that it can be done this way, and I had to go through all the trouble retyping the data. Thank you for this information. Dr Tin Htut" "A very good refresher of a little used feature. Hopefully more people will now be aware of this." "I have had to try to correct lists improperly entered more than once. Boy, I wish I had known about this. " "Another amazing tool which I never knew existed." "WOW!! Never knew there was a feature like this one!! Now I will have no trouble with the lists I may need to work with from time to time... Thanks a lot!" "Well I reallly enjoyed this presentation. this is first time I have come to know this feature of excel... It was a great learning for me.. keep up the gud work...." "Very informative. I've used excel for years and did not know how to split lists. thanks" "Beautiful! I was struggling with a similiar data task today. Now I can see the easy way. Thanks!"