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
3 ай бұрын
Thank you so much for the kind words Anne 🙂
@payaljain5497
2 ай бұрын
Hi Sumit, if you could provide the excel file for this video please? That would be really helpful...Thanks in advance😊
@sauravnath83
3 ай бұрын
@Trump Excel can we also get the desired results by using Power Query
@charlesrodriguez2176
2 ай бұрын
Great demo! FYI, you can also use the SORT function to add that layer.
@celyb8384
3 ай бұрын
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?
@WekomVideos
3 ай бұрын
Brilliant, this has given me an idea to streamline a recurring task to save time. Thank you so much, Sumit! 🤩🤩
@WekomVideos
3 ай бұрын
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,{".",",","'","!","@","#","$","%","&","(",")",":",";","-","/","+"})))
@hiteshk3007
2 ай бұрын
does this methos works with office 2019 without VBA code?
@muhammadkausar2842
2 ай бұрын
Textsplit function is not available in excel below 2022
@rajeevgosavi4514
2 ай бұрын
Sumitji, May I request you once again to please upload a video usingpower query method to remove duplicate from single cell.
@trumpexcel
2 ай бұрын
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.
@rajeevgosavi4514
3 ай бұрын
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.
@rahulamesar5387
3 ай бұрын
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
@RahulGupta-ig9gv
2 ай бұрын
Awesome trick
@hardiksolanki2295
2 ай бұрын
Thanks
@AshramSubba
3 ай бұрын
thank you sumit for sharing valuable content.
@soundaryasuresh1845
3 ай бұрын
Sir can't access dashboard excel file link sir
@Azhar_Khan383
3 ай бұрын
Awesome and amazing, Thanks Sir
@PaulEBrownbill
3 ай бұрын
Thanks for the video, very useful
@RudraEatingShow
3 ай бұрын
First comment ❤❤
@xeeshanahmad8757
3 ай бұрын
excellent 👍
@chakralamurali
3 ай бұрын
Excellent sir
@muhammadfuadmulla6102
3 ай бұрын
Not showing this formula in excel 2021. Please give me suggest from your end. thank you
@trumpexcel
3 ай бұрын
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
3 ай бұрын
@@trumpexcel Thank you so much for giving suggest.
Пікірлер: 28