Editing excel is fast and straightforward using DocHub. Skip downloading software to your computer and make adjustments with our drag and drop document editor in a few fast steps. DocHub is more than just a PDF editor. Users praise it for its efficiency and robust capabilities that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and send records for completion to other people. All of this, put together with a competing price, makes DocHub the ideal option to wipe out comma in excel files with ease.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the protection of your records, as we securely store them in the DocHub cloud.
hello and welcome to this excel tips video i am sumit bansal and in todayamp;#39;s video i am going to show you how to remove commas from numbers and text strings in excel so here i have this data and you can see there in these numbers there is a comma now in most cases the comma would be there because it is a part of the number formatting so for example here if i select this cell and i go to the formula tab you can see i donamp;#39;t see any comma here that is because there is no actual comma in the number it is only being displayed because it is part of the number formatting so all we need to do is to remove this comma just change the number formatting so here i would select all these cells i would go to the home tab here and within the number group i would click on the small dialog box launcher and when i do that it opens the format cells dialog box you can do the same thing by using the keyboard shortcut control one so select the cells hold the ctrl key and then press the one key