See all How-To Articles

How to Remove Asterisks (*) From Excel & Google Sheets

In this tutorial, you will learn how to remove asterisks (*) from text in Excel and Google Sheets.

 

remove asterisks initial data

 

Remove Asterisks (*)

In Excel, you can remove asterisks using the Find and Replace functionality. Say you have the list of names shown below with asterisks included.

 

remove asterisks initial data

 

To remove asterisks from all cells (replace them with blanks), follow these steps:

1. In the Ribbon, go to Home > Find & Select > Replace (or use the keyboard shortcut CTRL + H).

 

remove asterisks find and replace

 

2. In the Find what box, enter “~*” (tilde and asterisk), and click Replace All.

Leave the Replace with box empty to replace each asterisk with a blank (delete it). In an Excel search, an asterisk is a wildcard for any character; therefore, to search for it, you need a tilde before *. That way, Excel knows that you want to search for an asterisk and not just any character.

You can read more about replacing special characters in this article.

 

remove asterisks find and replace 1

 

3. You get the pop-up message with information on how many replacements are made (32 for this example). Click OK.

 

remove asterisks find and replace 2

 

As a result, all 32 asterisks are replaced with blanks, and you got a clear list of names in Column A.

 

remove asterisks final data

 

Remove Asterisks (*) in Google Sheets

1. In the Menu, go to Edit > Find and replace (or use the keyboard shortcut CTRL + H).

 

google sheets remove asterisks

 

2. In the Find box, enter “*” (just an asterisk), click Replace all, and (3) click Done. There’s no need for a tilde; Google Sheets does not read Find characters as wildcards.

 

google sheets remove asterisks 1a

 

The result is a list of names, in Column A, without any asterisks.

 

google sheets remove asterisks 2