Let’s look at an example using SNN numbers. Just as the name suggests, this feature allows you to find all of the cells that have a dash or hyphen in them, and then replace it with either a space character or a null (blank). Removing Dashes or Hyphens in Excel using the Find and Replace featureĮxcel already has a neat little feature called “Find and Replace.” Let’s look at two simple ways to remove dashes or hyphens in Excel. Worry not, there are a couple of other methods that are simple and effective in removing dashes and/or hyphens from your data so that you are only left with numbers or text. ![]() Removing dashes and hyphens one by one is simply not an option when you have large amounts of data. If you are thinking about going into the spreadsheet and removing each dash one by one, think again. You need to remove all of the “-” symbols and just keep the numbers. ![]() ![]() When working with data in excel (numbers or text), there may be times where the data has dashes or hyphens that need to be removed.įor example, say you have a large group of social security numbers in the following format: 123-456-789.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |