Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to remove all asterisk characters from cells in Excel?
In the article, the user will understand how to remove all asterisk characters from cells in Excel. The users have to analyze the data or random names to remove the asterisk symbol from all cells either by using the formula or by using the Ku-tools tab. This method may be completed utilizing a straightforward way within Microsoft Excel by using the Remove Characters tab to remove the asterisk characters. After eliminating all asterisk characters, increase readability and clarity of understanding the dataset in MS excel. Ambiguity retains in the database due to asterisk characters will also be eliminated.
Example 1: By Using the Formula
Step 1
Deliberate the Excel worksheet. Open the Microsoft Excel sheet and insert the data from the cells A1 to A12 as you need as shown below.
Step 2
In the Excel sheet, place the pointer in cell B2 and enter the formula to remove the asterisk character for cell A2. Enter the formula that is =SUBSTITUTE(A2,”*”,””) and press enter tab that will remove or delete the asterisk character in cell B2 for the name as shown below.
Step 3
In the Excel sheet, place the pointer in cell B3 and enter the formula to remove the asterisk character for cell A3. Enter the formula that is =SUBSTITUTE(A3,”*”,””) and press enter tab that will remove or delete the asterisk character in cell B3 for the name as shown below.
Step 4
In the Excel sheet, place the pointer in cell B4 and enter the formula to remove the asterisk character for cell A4. Enter the formula that is =SUBSTITUTE(A4,”*”,””) and press enter tab that will remove or delete the asterisk character in cell B3 for the name as shown below.
Step 5
In the Excel sheet, select the cells in the row B and use the fill handle tool to drag the names into cell B12 which will automatically remove the asterisk character in the row as shown below.
Example 2: By Using Ku-tools
Step 1
In the Excel sheet, select all the cells and locate the pointer within the ribbon dataset. There are various tabs comprised within the top corner. Place the pointer within the Ku-tools tab and connect to the tab that has countless options encompassed. On the Ku-tools tab, place the pointer and connect to the Text tab which has the drop-down menu. In the menu, choose and link to the option Remove Characters tab in the Editing group that will open the dialog box as shown below.
Step 2
In the dialog box, place the pointer and click on the checkbox Custom that will be checked. Locate the pointer in the drop-box and type * that will display all the data in the Preview pane then click on the OK button. In the sheet, the values will be automatically presented without an asterisk. This method will be removed the asterisk character in all the data in row A as shown below.
Conclusion
The users may use the easy instance to show how they can remove or delete the asterisk character in the present data that is included in row A. The users can use the formulation to remove the asterisk character then it will drag all the cells to delete the asterisk. We may use the Ku-tools tab to remove the characters with the Remove Characters tab which will remove all the asterisk at the same time. We have to practice the vital choices from the ribbon and update the data.
1K+ Views
To Continue Learning Please Login