Select the first cell of destination column, right click and select the Transpose (T) in the Paste Options section of the right-clicking menu. Within a few moment, you will see that the cell values of the column has been switched to a single line having ',' (comma) as the separator.ĭone? Wasn't it easy enough to convert a column of huge excel data to a line of comma separated values? How much time it takes for you to achive this? If you know a better solution, do let us know. Select the row you will copy horizontally, right click and select the Copy from the right-clicking menu.This will open the Paste Special dialog box. Right-clcik on the destination cell (D1 in this example) Click on Paste Special option. You can do this using Control + C (or Command + C) or right-click on the selection and then click on Copy. As shown in the below screenshot, enter ' ^p' in the ' Find what' field and enter ' ,' (comma) in the ' Replace with' field. Copy the column (or the range in the column). Now press ' CTRL + H' to open the ' Find and Replace' dialog.This will put the selected column in the word document but in plain text format. Paste Special dialog box will appear, click on Validation Click on ok. Now open word document, right click on it and from the context menu, select ' Paste Options' as ' Keep texts only'. Copy the cell C3 by pressing the CTRL+C and paste in cell D1, select the cell D1 and right click of the mouse, select Paste Special from the popup.Open your excel sheet and select the cells of the column that you want to process.

If you don't want to do that and want the job done by yourself, here's the easy steps:

Copy and paste list into excel