Remove Duplicates Within a Cell in Excel (2 Easy Ways)
ฝัง
- เผยแพร่เมื่อ 30 ก.ค. 2024
- In this video, I will show you how to remove duplicates from a cell in Excel using formulas.
While removing duplicates from a range of cells where each value is in a different cell is quite easy, when it comes to removing duplicate items within a cell, you need to somehow analyze the entire content of the cell and then remove the duplicate values.
Thankfully, this can quickly be done using new Excel functions such as TEXTSPLIT, UNIQUE, and TEXTJOIN.
And if you do not have access to these new functions, you can create your own function using a simple VBA code.
VBA code available here - trumpexcel.com/remove-duplica...
00:00 Intro
00:00 Using TEXTSPLIT, UNIQUE and TEXTJOIN
00:00 Using VBA to create custom function
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: th-cam.com/users/trumpexc...
#Excel #ExcelTips #ExcelTutorial #SumitBansal
I’ve been following you for quite a while now… And I now know why! Your explanations are so clear and concises! No frill, no bells and whistles just plain English and simple examples.Thank you so much Sumit for all the good work that ends up making us better.
Thank you so much for the kind words Anne 🙂
Great demo! FYI, you can also use the SORT function to add that layer.
Brilliant, this has given me an idea to streamline a recurring task to save time. Thank you so much, Sumit! 🤩🤩
And it worked!! I repeatedly need to remove all special characters from a long text string in a multiple cells and by using this formula I'm able to do it in a few clicks rather than removing each special character one by one using the Ctrl + H replace function.
This is epic, thank you!
=TEXTJOIN(" ",TRUE,TRIM(TEXTSPLIT(E2,{".",",","'","!","@","#","$","%","&","(",")",":",";","-","/","+"})))
thank you sumit for sharing valuable content.
Excellent Fantastic marvellous super
Thanks for the video, very useful
Awesome and amazing, Thanks Sir
Thanks for giving such a brilliant tip. Really useful. Could you also upload a video on how to remove duplicates within a cell using Power Query. Thanks.
Awesome trick
Excellent sir
Thanks
excellent 👍
Sir it will be great if you make some.case studies video on power query that could be used for most frequently done office work.
Really love your work. Thanks
@Trump Excel can we also get the desired results by using Power Query
Thank you Sumit for this function, however if the sheet has 2000 rows with more than 4 different characters, is there an easy way to get the characters within the sheet? the formula will only apply if the specified characters are mention. Is there a default character that will represent the bunch of characters?
does this methos works with office 2019 without VBA code?
Hi Sumit, if you could provide the excel file for this video please? That would be really helpful...Thanks in advance😊
Sumitji, May I request you once again to please upload a video usingpower query method to remove duplicate from single cell.
Ok sure... let me try and figure out how to do this with PQ, and then will create a video about it. I already have the next two videos lined up, so will try and make this one after that.
Textsplit function is not available in excel below 2022
Sir can't access dashboard excel file link sir
First comment ❤❤
Not showing this formula in excel 2021. Please give me suggest from your end. thank you
The formula I showed will work only if you have the new functions (I think all are available on Excel with M365 only). You can use the VBA method though which works in all the versions of Excel
@@trumpexcel Thank you so much for giving suggest.
Thank you sir for sharing VBA code