Convert column list to comma separated list with VBA 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. 1. Hold ALT button and press F11 on the keyboard to open a Microsoft Visual Basic for Application window. 2...