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

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on February 25, 2023

This tutorial demonstrates how to remove asterisks from text in Excel and Google Sheets.


remove asterisks initial data


Remove Asterisks (*)

In Excel, you can remove asterisks using Find and Replace. 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


  1. 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 tutorial.

remove asterisks find and replace 1


  1. 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


  1. In the Find box, enter “*” (just an asterisk), click Replace all, and 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

AI Formula Generator

Try for Free

See all How-To Articles