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.
- How to convert commas into dots in Excel
- Change the slash to a dot in Excel format
- How to use underline styles in Excel
- 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.
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.
The display indicates the number of characters to be removed from the dot, press OK to return to the data table interface.
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.
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.
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.
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!
You should read it
- Instructions for searching and replacing in Excel tables
- Difference between REPLACE and SUBSTITUTE in Microsoft Excel
- Complete guide to Excel 2016 (Part 10): Use the Find and Replace function
- Instructions on how to count words in cells in Excel
- This is a simple way to find and delete Hyperlink in Excel
- How to use the FIND and REPLACE functions in Excel?
- Instructions for using the Find and Replace functions in Excel
- How to fix the SUM function doesn't add up in Excel
May be interested
- How to create and delete tables in Excelhow 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. 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 formatby 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 Excelmicrosoft 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 Excelusually 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 examplesthe 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 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 Excelto 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 Excelnumbers 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 Excelto 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.