Archive | August, 2015

Convert an excel column into a comma separated list

10 Aug

Type the formula into the second column first cell as =A1 ( imagining A has all the data you need)

Type the formula into the second column second cell as =B1&”,”&A2

Drag till the end.