From the Home tab, click on the ‘ Find and Select’ button under the ‘Editing’ group.Let us assume you want to work only on the data in Column B. If you want to remove commas from a specific part of your worksheet, select the group of cells you want to work on. 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).You can also use it to replace the commas with space (or any other character). You can use Excel’s Find and Replace option to selectively remove commas from the cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |