Google Sheets: How to Replace Comma with Dot


The easiest way to replace commas with dots in Google Sheets is by using the Find and replace function within the Edit tab.

The following example shows how to use this function in practice.

Example: Replace Comma with Dot in Google Sheets

Suppose we have the following dataset in Google Sheets that shows the average points scored by basketball players on various teams:

Suppose we would like to replace each of the commas in the Average Points column with dots instead.

To do so, highlight the cell range B2:B11, then click the Edit tab and then click Find and replace.

Note: You can also type Ctrl + H as a shortcut key to bring up the Find and replace window.

In the new window that appears, type a comma in the Find box, then type a dot in the Replace with box:

Google Sheets replace comma with dot

Then click Replace all and then click Done.

Each of the commas in the Average Points column will automatically be replaced by dots:

Note #1: Make sure you click Replace all before clicking the Done button or else the commas will not be replaced by dots.

Note #2: If you would like to perform the reverse operation (replace dots with commas) then simply type a dot in the Find box and type a comma in the Replace with box instead.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Replace #N/A Values in Google Sheets
How to Replace Text in Google Sheets
How to Replace Blank Cells with Zero in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *