Really this is the right way? would we get award for using this complex and long formula.We are living in A.l era where work is supposed to be done instantly and right.
Cool to see and nice to know that this is possible but this one would be nice with a little more explanation. For example, are all special characters manually listed or was there a formula used? Had no idea this was possible.
Thank you Alexander. Glad you find it helpful. This formula let us list the characters we want to remove from the string. We can hardcode it in formula if we want, but this way we have more flexibility.
Noted! With a minute window I really wish to make the best of it. But explainers require a long form videos that are in works. For now I can help in comments if anyone have confusions or questions :) And super glad to have you here!
Excel LAMBDA function is not available in 2021 version yet. But you can use Excel for web or Excel apps for Android iOS to practice and use this function for free.
Is there a way to do this same thing but for different text with characters within a list. ex: (Happy) (Sad) (Big) (Tall)? Helpful video btw, thank you.
You are freakishly good 👍🏻
Really this is the right way? would we get award for using this complex and long formula.We are living in A.l era where work is supposed to be done instantly and right.
Perfect! Makes sense!
Awesome
tnq 👌❤
In what cases we using? Thanks thanks...
Data cleanups
CSV files
Imports from unsupported sources
Cool to see and nice to know that this is possible but this one would be nice with a little more explanation.
For example, are all special characters manually listed or was there a formula used?
Had no idea this was possible.
Thank you Alexander. Glad you find it helpful.
This formula let us list the characters we want to remove from the string. We can hardcode it in formula if we want, but this way we have more flexibility.
which area select after then you goto name define box tell me
Useful video but you should have atleast explain us that formula......then it would have become more easier for us to apply the formula.
Noted!
With a minute window I really wish to make the best of it. But explainers require a long form videos that are in works.
For now I can help in comments if anyone have confusions or questions :)
And super glad to have you here!
@@LearnExceltoexcel thanks
Why are you not posting any videos.. your Excel tips has helped me a lot
Can I apply office 2021 ?
Excel LAMBDA function is not available in 2021 version yet. But you can use Excel for web or Excel apps for Android iOS to practice and use this function for free.
Clean function is easy way then this
😊
💡
Is there a way to do this same thing but for different text with characters within a list. ex: (Happy) (Sad) (Big) (Tall)? Helpful video btw, thank you.
I didn't get this result
can you do short video about removing special characters in full name, for example it mike*"#han"opol then it will turn into mike hanopol
As I understand there is no space in the mixed data but you want it
For which character we should have space instead?
Seems a little very long “shortcut” with no explanation