How to delete dots in a series of numbers on Excel

Often long numbers on Excel have extra dots to separate, making it easier to observe data as well as minimize the possibility of errors and mistakes when entering data. However, in some calculation cases, deleting the dot in the range of Excel required. If the data is small, it can be done manually, but most of the tables on Excel are very long. So you can use a search engine on Excel or a function in Excel to quickly remove dots in the range of numbers in Excel. The following article instructs you to read how to delete a quick dot in the Excel range.

  1. How to convert commas into dots in Excel
  2. Change the slash to a dot in Excel format
  3. How to use underline styles in Excel
  4. How to write dash in Word and Excel

1. How to delete dots in Excel with Replace

Step 1:

Users black out the number range to remove the dot in Excel. Continue to click Find & Select and then click on Replace at the Home tab.

How to delete dots in a series of numbers on Excel Picture 1

Step 2:

In the Find and Replace dialog box, click the Replace tab and then enter the dot in the Find what field , in the Replace with box, and click Replace All to change the dot.

How to delete dots in a series of numbers on Excel Picture 2

The display indicates the number of characters to be removed from the dot, press OK to return to the data table interface.

How to delete dots in a series of numbers on Excel Picture 3

The whole dot has been removed. In case you enter the phone number and the number 0 disappears, it is possible to re-display 0 in Excel according to the article How to display 0 in front of the number in Excel.

How to delete dots in a series of numbers on Excel Picture 4

2. How to delete the Excel dot with SUBSTITUTE function

Step 1:

In the next cell to delete the dot, we enter the formula = SUBSTITUTE (Text, Old_text, New_text) . Applying for the case of deleting the dot in the sequence, understand the formula = SUBSTITUTE (the text to be checked, the character to be changed, the new character to replace the old one).

So the formula to remove the dot is = SUBSTITUTE (E2, '.', '') And then press Enter.

How to delete dots in a series of numbers on Excel Picture 5

Step 2:

The result of the sequence is to remove the dot. We click on the first result box and drag down the remaining cells to complete the data table results.

How to delete dots in a series of numbers on Excel Picture 6

With two simple ways we can quickly delete the dot in the range of numbers on Excel. Whether you use the SUBSTITUTE function, or the Find & Replace search engine, produces similar results.

I wish you all success!

4.2 ★ | 194 Vote

May be interested

  • How to create and delete tables in ExcelHow to create and delete tables in Excel
    how to create and delete tables in excel. excel is a great tool for calculating, it supports many calculation functions, logical functions ... but for the numbers to be presented scientifically and beautifully you need to create tables for data. this article helps you to create and delete tables in the table
  • Create dots in Word, how to create dots lines, tab line dots (.........) in WordCreate dots in Word, how to create dots lines, tab line dots (.........) in Word
    create dots in word, how to create dots lines, tab line dots (.........) in word. students writing essays, projects, or paper forms will often have dotted lines to fill in the content. if you often have to draft these documents, you cannot enter them
  • Change the slash to a dot in Excel formatChange the slash to a dot in Excel format
    by default, the excel date format often uses slashes, such as march 23, 2016 .... however, if your worksheet has multiple dates lists, you can use dots. in date format to make the worksheet easier to see, no glitches.
  • How to extract numbers or text from ExcelHow to extract numbers or text from Excel
    microsoft excel is great for working with both numbers and text, but if you use both in the same cell, you may have some difficulties. fortunately, you can extract numbers or text from cells to work with your data more efficiently.
  • How to display 0 in front of a number in ExcelHow to display 0 in front of a number in Excel
    usually when we enter a sequence of numbers in excel that has a leading zero, it will disappear. so how to display 0 in the series in excel?
  • MEDIAN function in Excel, how to use and examplesMEDIAN function in Excel, how to use and examples
    the median function in excel helps you calculate the median of a series of numbers, which is the middle value when the numbers are arranged in ascending order. this is a useful tool in statistics and data analysis.
  • How to format numbers in ExcelHow to format numbers in Excel
    how to format numbers in excel in the process of working, processing data in excel sometimes you need to format numbers in excel so that data can display the number format in accordance with the requirements to be processed. you do not know how to format numbers in ex
  • How to convert negative numbers to positive numbers ExcelHow to convert negative numbers to positive numbers Excel
    to convert negative numbers to positive numbers and vice versa on excel, you only need to perform a very simple operation.
  • How to convert Apple Numbers documents to Microsoft ExcelHow to convert Apple Numbers documents to Microsoft Excel
    numbers is spreadsheet software specifically for apple devices both on phones and on computers. basically, apple numbers works similar to microsoft excel, so you can completely convert documents between these two toolkits to serve each specific working situation.
  • Instructions for converting numbers to words in ExcelInstructions for converting numbers to words in Excel
    to convert numbers to words in excel, you will use a support tool, instead of typing by hand, which is not accurate and takes a lot of time to do. below are some ways to convert numbers to words in excel.