(1) Check the Combine rows option in the To combine selected cells according to following options section In the opening Combine Columns or Rows dialog box, you need to: Select the column list that you will convert to a comma separated list, and click Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data.Ģ. Full feature free trial 30-day, no credit card required! Get It Nowġ. Kutools for Excel- Includes more than 300 handy tools for Excel. You can also apply Kutools for Excel’s Combine utility to combine a column list, and separate each value with comma easily.

Tip: In the above VBA, ',' indicates the separator you need, and you can change it as you need.Ĭonvert column list to comma separated list with Kutools for Excel Click OK, and all values in the column list have been converted to a list separated by comma in a cell. Click OK, then another dialog popped up for you to select a cell. A dialog displayed on the screen, and you can select the column list you want to convert. Click Run button or press F5 to run the VBA.Ĥ. Set OutRng = Application.InputBox('Out put to (single cell):', xTitleId, Type:=8)ģ.

Set InputRng = Application.InputBox('Range :', xTitleId, InputRng.Address, Type:=8) VBA: Convert column list to comma separated list Sub ChangeRange() Click Insert > Module, and copy the VBA into the module. Hold ALT button and press F11 on the keyboard to open a Microsoft Visual Basic for Application window.Ģ. If the CONCATENATE function is a little tedious for you, you can use a VBA to quickly convert the column list to a list in a cell.ġ.

Excel transpose cells with common