Step 5: Use or Paste your comma separated values anywhere without any issues. Step 4: Copy your comma separated list on the right. Step 3: It automatically convert any column data to comma separated list. ListRow = 1: Rem the row in column B that is getting writtenĭo Until Cells(dataRow, 1).Value = '' And Cells(dataRow + 1, 1).Value = ''ĭata = data & ',' & Cells(dataRow, 1). One solution you might consider is selecting just the date cells in your spreadsheet and doing a Find and Replace for the character. (Example: Excel column data) Step 2: Paste the column on the left or type data in columns.

As our data is neither separated by Tab, Semi-Colon, or a comma, but it’s a Hyphen (-) and Space. In the current example, a character separates the data, so we will use a delimited feature again. Select Column B, then go to the text to Column under Data Tab and click it. So modified the routine and came up with the following, also I changed the variable names to meaningful names: Sub generatecsv()ĭataRow = 1: Rem the row that it is being read from column A otherwise known as 1 in vb script Use the CONCATENATE formula to join 2 cells together at a time, then join those 2 together in the next column and so on. Select Column C and insert three columns. Reason, I had a client send me multiple keywords in list format for their website based on subject matter, needed a way to get these keywords into the webpages easily. Lets look at some of the cool things you. You can also use the keyboard shortcut ALT + A + E to access the text to column wizard. Using this method would open the Convert Text to Columns Wizard. example list title 1Īnd combines them of course into multiple rows, 1 per list. Text to Columns can be accessed by selecting the dataset and then proceeding to Data > Data Tools > Text to Columns. I improved the generatecsv() sub to handle an excel sheet that contains multiple lists with blank lines separating both the titles of each list and the lists from their titles.

Convert excel columns to text