VBA macro to delete duplicate text from multiple cells at once Like any other Excel function, our UDF recalculates automatically when the source data changes, so your results will always be up to date. If your source data is separated by a space, the second argument should be " " or omitted: If you'd rather get a comma-separated list, then use only a comma for the delimiter: Define the arguments, type the closing parenthesis, press Enter, and your formula is completed.įor example, to delete duplicate words separated by a comma and a space from A2, enter the below formula in B2, and then drag it down through as many cells as needed:Īs the result, you will have a list of unique words or substrings separated by a comma and space: Double-click on the function, and you'll have it inserted in a cell. Just start typing the function's name after the equal sign, and it will appear in the formula intellisense. Once the function's code is added to your workbook, you can use it in your formulas the same way as you use Excel's built-in functions. The function is not case-sensitive, meaning that lowercase and uppercase letters are treated as the same characters. If omitted, a space is used for the delimiter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |