Forcing text to align with specific column in Excel?

[jent]

I have Excel 2011 for Mac and pasted a text document I typed out in TextEdit. In TextEdit I hit tab enough times so that the second "column" aligned despite varying lengths in email addresses.

When I pasted this text into Excel, the second "column" ends up being spread over several columns. I was wondering if there's an easy way to force all of these into the B column. Thanks!

I'm including screenshots of the text in TextEdit and Excel. I whited out the email addresses on the left side of each document.

 

[snberk103]

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.

 

[samh]

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.

 

[miles01110]

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.