The method described above, leaves the original column intact. To remove the commas from numeric fields, we need to change the cell formatting by invoking the Format Cells dialog box.īefore we do this though, we are going to take a look at another couple of ways of removing commas in text fields. In fact, if we attempt a Find & Replace on just the Subscription Fees column, we would get something like the above Excel warning. This is because the Find & Replace functionality only works for text fields, and the Subscription Fees column is numeric.
Notice however, that the Subscription Fees cells, still contain a comma. You can also use the keyboard shortcut, Ctrl-A.Īs before, you only need to now bring up the Find and Replace dialog box and perform the replacement. To select the entire worksheet, click on the square at the top left of the worksheet, at the intersection where the row numbers start and to the left of where the column letters start. In fact, we can do this for the entire worksheet. The Find what and Replace with input fields would be exactly the same. The same process can be used to remove commas from both the Name and Address columns.Īll we need to do is select both columns before invoking the Find and Replace dialog box.
The previous process removed commas from cells in a single column.
Our Name column will still contain the subscriber names, but now with all commas removed. We click on the Replace All button and an info message pops up telling us how many replacements were made.Īssuming all went well, we can click the OK button to close the message, and then the Close button to close the Find and Replace dialog box. In the Find what input field, we enter a single comma, and in the Replace with input field we only to ensure it is blank. This is a fairly straightforward search and replace, so we only need to concern ourselves with the Find what and Replace with input fields. In either case, you should now have the Find and Replace dialog box on screen. You can also use the keyboard shortcut, Ctrl-H. In the Home tab, on the far right in the Editing group, click on the magnifying glass icon or the Find & Select option, and from the context menu that pops up, select Replace…. To do a find and replace, we need to call up the Excel Find and Replace dialog box. In this case, we are going to replace them with nothing, a blank. We are going to ask Excel to look for any commas in the cells we have selected, and replace them with anything we want. The method we are going to use involves nothing more than doing a find and replace. Start by selecting a single cell, a range of cells, or the entire column, depending on which cells you want to remove the commas from.
EXCEL ADD COMMAS IN NUMBERS HOW TO
We will look at how to remove all commas from both the text columns and the numeric column.įor now, assume that we only want to remove commas from the Name field (later we will also look at how to remove all commas in a worksheet). Similarly, the address comprises the number and street, city, and county, separated by commas.įinally, the subscription fee is a dollar value amount with a comma for the thousands separator. The subscriber name is made up of the last name and first name, separated by a comma. Here’s How to Remove Commas in Excel from Numbers or Text:Įxcel basically has three data types: text, number, and boolean.Ĭommas cannot be used with the boolean type so is not considered here.įor our purposes, we will be using the following worksheet which contains a list of subscribers.įor each subscriber, the list includes their name, address, and yearly subscription fee. However, in a spreadsheet, there may be times when a comma serves no purpose, or is just simply not desirable.Īnd in this article, we are going to take a look at a few different ways that you can use to remove them. Without the comma, this has a totally different, cannibalistic intent. In a text document, a comma can help give the correct meaning to a sentence.Ĭonsider the phrase “Let’s eat, Grandma”. If we add commas, the number which now becomes 456,290,713, can now be read without hesitation. To read it, you visually try and break down the number into groups of three digits, going from right to left, to determine if the number is in the millions, billions, trillions, etc. For example, consider the number 456290713. There are several ways to Remove Commas in Excel from Numbers or Text.Ī comma is a separator used to give structure and meaning to both text and numbers.Ī very large number is easier to read with commas.