How to paste text to column:
- Copy all of your tab-delimited text. Tab-delimited text is a format for storing data from a spreadsheet as a text file.
- Select the cell in Excel that you want to paste into. Select the upper-leftmost cell that you want your pasted data to appear in.
- Paste the data. In newer versions of Excel, and if your data was properly delimited with tab stops, the cells should fill out appropriately with the correct data.
- Select the entire column of data. If your tab-delimited data did not paste correctly, you can use Excel's Text to Columns tool to format it properly.
- Open the Data tab and click "Text to Columns". You'll find this in the Data Tools group in the Data tab.
- Select "Delimited" and click "Next". This will tell Excel that it will be looking for a specific character to mark cell divisions.
- Select the character that your data is separated by. If your data is tab-delimited, check the "Tab" box and uncheck any other boxes.
- Choose the format of the first column. After selecting your delimiter, you'll be able to set the data format for each of the columns that are being created.
- Repeat for additional columns. Select each column in the frame at the bottom of the window and choose the format.
- Finish the wizard. Once you have formatted each of the columns, click Finish to apply the new delimiter.