To remove all dashes and everything after them, replace “-*” with nothing (the * serves as a wildcard).To remove all blanks, replace ” ” (a blank) with nothing.To remove all # signs, replace # with nothing.What’s A Good Use For Find And Replace In Excel?įind and Replace can be a great way to clean up data in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |