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.
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,{".",",","'","!","@","#","$","%","&","(",")",":",";","-","/","+"})))
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
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.
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?
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.
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
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,{".",",","'","!","@","#","$","%","&","(",")",":",";","-","/","+"})))
Awesome trick
Excellent Fantastic marvellous super
Thanks
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
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
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.
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.
Hi Sumit, if you could provide the excel file for this video please? That would be really helpful...Thanks in advance😊
does this methos works with office 2019 without VBA code?
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
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