Blog

How to Remove star or Astericks Character from the Text in Excel

How to Remove star or Astericks Character from the Text in Excel


                                Many time we will find the difficult while downloading the data from the software as the text will contain “*” character in between the text and it very difficult to remove by using the usual method of Find and Replace option and which will remove all the texts.


 


 

Here we can use another hidden option by using Tilde key in the keyboard just above the Tab Key.

By using Find and Replace option by typing Tilde character and after that type “*” character and replace the same with a blank . And now we can see all the “*” character is removed.


 




Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.