No Links were listed yet. Go ahead and share!
Hey welcome back to the Mr. Excel net cast. I’m Bill Jelen. Face it, you start out massive amounts of data, so how are you going to analyze this, well lets fire up the pivot table and see if we can solve this problem.
Welcome back to the Mr Excel net cast, I’m Bill Jelen, today’s questions sent in by Todd. Todd has data from the Minnesota lottery and it all comes in into a single cell, they don’t put the commas between the various variances, he says “how can I split those out to various columns”; we’re going to use couple of tricks here. First of all select the whole column, ctrl + Shift down arrow and then on the data tab, we’re going to use text to columns. Now in excel 2003 you go to the data menu and choose text to columns. And we’re going to say that this data actually we have a choice, we either say that it’s fixed with or that would work because they where very careful to put the leading zeros her in the dates or, we can say that’s it’s still limited based on a space, either one would work. Now let’s choose fixed with, you see they put all of the lines in here, if any of those where wrong, we could drag it to a new place, or follow the instructions up here. Double click to delete her, click to add a new one, we’ll click next. Now you want to make sure that this first field the date field is declared as a date in month day year format, the others you can just leave as general, click finish and there we are, everything is broken out into a various columns and we’re good to go. Now you can now start to do some pivot table or something along those lines.
Ok there you have it, thanks for stopping by; we’ll see you next time for another net cast, from Mr. Excel.
Transcription by:
Scribe4you Transcription Services