![]() The first thing I'm going to do is try and find the colon and delete anything after that. So now I have a copy that I can work on, without any concerns about the original data. Then we'll go to Sheet2, click here and paste. So I'll select these two columns and copy them. So either make a copy of the whole workbook or at least make a copy of the names you're going to work on. I want to keep that safe in case I have to go back to it. Make a Backup of Dataīefore I make any changes, I'm going to make a copy of this data. We also have someone with OF in their name, and we want to make sure that doesn't get affected. So we have law office of, law offices of, and the law office of. We also want to remove the space before the hyphen.Īnd the third thing we want to do is find any that have the word of remove that word, the space after it, and anything before that. Again, we want to remove the hyphen and anything after it. So we want to remove the colon and anything after that. So here's the name of a law firm, a colon, and then the name of an individual there. In this column, we want to get rid of anything that's after a colon. These are all fake names, but we'll see how you can remove text, either before or after a specific character or string of characters. I've been given a list of names to clean up in Excel, and this is just a small sample of a long list. ![]() Here is the full transcript for the video: Find and Replace with Wildcards Video Transcript: Find & Replace With Wildcards However, for a one-off job, this is a quick way to clean things up NOTE: If you need to do this type of cleanup frequently, you could create a macro to do the steps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |