Cut Paste Comma Delimited text into Excel 2010. To Display correctly go to Data, Text to Columns

In this video I show how I properly display a comma delimited cut and paste into excel 2010.

Excel 2010 does not automatically convert the copy and pasted comma delimited text.
After pasting, you have two methods (probably more)

Method one, there is a little icon "ctrl"
click this, then click on "Use Text Import Wizard"
Follow the wizard steps
In first step make sure it's set to delimited radio button
in second step, make sure the delimiter is check marked comma.
Click Finish.

Method 2 is similar to the first except we use the top menu navigation buttons to get to the Text to Columns wizard
First paste your text into excel 2010
Then at top menu, click on Data tab
Then click on the Data Tools: "Text to Columns" wizard button
Complete steps in Text to Column wizard
Step 1 select radio button delimited
Step 2 of wizard check mark the delimiter comma. Uncheck all others.
Click Finish.

VOILA.. I'm sure in excel 365 or whatever.. it does it automatically now.. but if it doesn't.. you can use these two methods.