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.

@trumpexcel

29 күн бұрын

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! 🤩🤩

@WekomVideos

27 күн бұрын

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,{".",",","'","!","@","#","$","%","&","(",")",":",";","-","/","+"})))

Awesome trick

Excellent Fantastic marvellous super

Thanks

thank you sumit for sharing valuable content.

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 and amazing, Thanks Sir

Thanks for the video, very useful

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

Excellent sir

excellent 👍

@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?

Sumitji, May I request you once again to please upload a video usingpower query method to remove duplicate from single cell.

@trumpexcel

11 күн бұрын

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.

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😊

Textsplit function is not available in excel below 2022

First comment ❤❤

Sir can't access dashboard excel file link sir

Not showing this formula in excel 2021. Please give me suggest from your end. thank you

@trumpexcel

Ай бұрын

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

@muhammadfuadmulla6102

Ай бұрын

@@trumpexcel Thank you so much for giving suggest.

@girishpadshala9689

Ай бұрын

Thank you sir for sharing VBA code