How to Remove Duplicates from a Single Cell in Excel 🔥[EXCEL TIPS!]

[@oliviaoob1426]

This tutorial was exactly what I needed for a project I'm working on! Thank you!!!!

[@SpotlightImpact]

I’m so glad it was useful! I hope you’ll share and subscribe 🙏🏻

[@RSolitaire]

I like your way of explaining things - so simple

[@SpotlightImpact]

Thanks for watching 🙏🏻

[@StephanieGiese-z2e]

Exactly what I needed thank you!!

[@SpotlightImpact]

Yay! I’m glad it’s useful! I hope you’ll subscribe and share 🙏🏻

[@odohib8798]

this is only feasible if you have a relatively small data set, what if you are dealing with hundreds of unique data sets ? is there a video tutorial you can suggest?

[@SpotlightImpact]

I will do some sleuthing to see what I can find. I may also back into some of the Miss Excel Exeleraror course to see if she’s got any tricks about this one - it might involve creating some VBA behind the scenes. links.miss-excel.com/exclusive?ref=nick91

[@mehar5843]

What formula we have to apply if there is blank in between words and digits in cells for splitting that values

[@SpotlightImpact]

You’ll want to check out the =TRIM function for that.

[@Makki0531]

A bit long process, but works fine for me, thanks a lot for the tutorial 😉😉

[@SpotlightImpact]

It is long! I bet there’s an easier way with VBA I just don’t know how 🤷🏼 thanks for watching!

[@moesadr3342]

What if, we only have one column and need to highlight those with the first 5 matching characters on the same column?

[@SpotlightImpact]

You'll likely want to use the LEFT function to first spit out a new column with the first five characters of your source colum www.customguide.com/excel/excel-left-function - after that though I'd have to sit with it more to figure out how to match or highlight. You might want look up the INDEX and MATCH functions, those could be of use here too.

[@ManojKumar-ip5gx]

by power query?

[@SpotlightImpact]

I bet power query would be a better way! I’m not very familiar w it yet. Thanks for watching! 🙏🏻

[@erolarmstrong]

my dataset has cells like this N2 = IndiaIndiaIndia, N3 = GermanyGermanyGermanyGermany, and further, the repetition of country names together isnt constant, some cells have more than 6 repetition. i want to know how i can solve it to make it come up once like N2 = India, N3 = Germany. I am trying to get each character and match, i think i need a for loop which is not in excel which am realizing it now while writing this comment.

[@SpotlightImpact]

That one's a tough one - do you have a full list of the unique countries used? My first thought might be to use the "LEFT" function which returns a set number of characters from a string of text. For call N2 with IndiaIndiaIndia in 02 you would type =LEFT(N2,5) and that would return "India". That will only work for countries with 5 characters in their name though there's still a lot of manual cleaning involved I think. I'll have to noodle on this one and see if there's a good solution to post. Thanks for the question.

[@SpotlightImpact]

You might also try using Flash Fill which will work for any country name that starts with a capital letter and only includes one word. kzbin.info/www/bejne/nnzFZ4SCfc93bsU

[@erolarmstrong]

@@SpotlightImpact woah ty for replying, ill look into it

[@erolarmstrong]

@@SpotlightImpact ty for the help, ill keep on working on the solution, i just started to learn data cleaning

[@SpotlightImpact]

@@erolarmstrong you’re welcome. You got this 💪

[@RSolitaire]

If you have discovered a better way, please share