Home Ribbon|Clip Board Group|Paste Button|Paste Special|Text (pasting as HTML will usually not allow charting of data)
If data does not parse into individual columns, use Data Ribbon|Data Tools|Text to Columns?
Fixed Width: if Courier font is used or if width of each character is the same
Delimited: a consistent character is used between each piece of data
Step 2 of wizard allows for column adjustment (add, remove or change) for fixed width fonts or adding of a delimiter if it is not listed for delimited text