How to Delete Dots in a Series of Numbers on Excel

The following guide provides a clear overview of Delete the Excel dot, with the most relevant background, details, and practical takeaways.

• 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!