From Selection, choose Add Cursors to Line Ends by pressing SHIFT+ALT+I (or SHIFT+OPTION+I).Select all by pressing CTRL+A (or Command+A for Mac).Use Multi-Line Editing Visual Studio Code Replace All by pressing Option+Command+ENTER.Ģ.Make sure Regular Expression is turned on ( Option+Command+R).Replace All by pressing CTRL+ALT+ENTER.Make sure Regular Expression is turned on ( ALT+R).The only difference is the shortcuts between PC and Mac. If you want to remove commas from a specific part of your worksheet, select the group of cells you want to work on. This works the same way in both Visual Studio Code and Sublime Text. Here’s how you can do this: If you want to remove commas from the entire sheet, press CTL+A on your keyboard or the select All icon (the small gray icon at the top-left part of the sheet). Using either Visual Studio Code or Sublime Text, we can accomplish this task in a matter of seconds. In the past, we would probably write a macro module in Excel, but other than a security risk, it’s overcomplicating a simple task. The goal is just to add a comma at the end of each line so it can be used to update data in a database table. The data would look like the following: 87295 We received a CSV with thousands of ID numbers that will be used to update a database table. You can also select the entire spreadsheet by clicking the gray cell between the row A heading and the column 1 heading.Sometimes the simplest thing is really taken for granted and we take the long route to do the simplest thing. You can select an entire row by clicking the row number at the side of the spreadsheet, or you can select an entire column by clicking the column letter at the top of the spreadsheet.

Step 2: Select the cells containing numbers that have commas. Step 1: Open your spreadsheet in Excel 2013. The steps in this article will show you how to change the formatting for a selection of numbers in your Excel spreadsheet so that those numbers display without a comma. How to Remove the Comma from Numbers in Excel 2013 Our convert text to number Excel guide can show you how to switch data types. Microsoft Excel has a lot of formatting options that let you choose how to display your data. Our tutorial below will show you how to change the formatting option for cells that are formatted as numbers so that those numbers display in your cells without that comma. Are some of the numbers in your spreadsheet currently formatted to display commas as a 1000 separator? This is an option in Excel, and it is one that you don’t need to use if you don’t want it.

Excel add commas in numbers