Forcing text to align with specific column in Excel?

I'm not an Excel user, but it should be enough like Numbers in this case.

It's the tabs you inserted, imo, that are causing the problems. Strip them out in the text document and then try it again. I'm thinking the tabs are a signal to Excel to go to the next cell for the next entry.

Once the tabs are stripped there should be a way to paste down into a column. Or you can start with a single column spreadsheet to paste into that, and then add the columns you need.

 

Exactly. Just one one tab after the email address and they will all end up in column B.

 

You could probably use the concatenate function if all of the cells are the same size (if you have merged cells I don't think it will work) which should be the case if you just copy/pasted the text into the worksheet. Excel doesn't merge cells by default.