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.
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.
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!
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.
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.
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.
You are freakishly good 👍🏻
Perfect! Makes sense!
Awesome
tnq 👌❤
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.
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
I didn't get this result
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.
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?
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.
Seems a little very long “shortcut” with no explanation
😊
💡