![]() Remove specific characters: (such as: numeric, alpha, non-printing, specific characters, etc.) As they are formulas, when you copy and paste them, please paste them as values to prevent the formulas making errors. Then select cell B1, and drag the fill handle down to the range cells that need apply this formula, and all the asterisks have been removed from the cells, see screenshot:ģ. Enter this formula: =SUBSTITUTE(A1,"*","")into a blank cell besides your data, B1, for instance, and then press Enter key, see screenshot:Ģ. ![]() Here is a simple formula may help you to remove the asterisks from cells. ![]() Remove all asterisk characters from cells with Kutools for Excel Remove all asterisk characters from cells with Find and Replace function Remove all asterisk characters from cells with formula I am working with a worksheet which contains some asterisks within the cell contents, now, I want to remove all these asterisks from the cells, how could I solve this problem in Excel? How to remove all asterisk characters from cells in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |