Sublime Text a Useful Text Editor

Many of us went through the scenario where you extract records out of CRM and have them as a csv/excel sheet and you want to create a comma delimiter file out of the records.

Here is how:

We have a list of numbers in an excel file where we want to create a comma separated list from all the Member Ids.

For instance we have the following excel sheet:

We want to create a comma separated file only from MemberId column First select the column in excel copy and paste the results in sublime text editor

Now select the end of the first line using shift + arrow keys, this will highlight the selected space at the end of the first line:

Now press Alt+F3, this will enforce the same selection on “all of the lines” within the file

then type comma (“,”) and viola!  

It added a comma at the end of every line :)