How to find special/weird characters in Excel?
I attached below some rows I have which you can clearly tell have some weird characters in the text. Is there a formula to find which rows have any of these characters, and which don't. I think that these aren't all of the special characters in the texts, meaning there might be other that I didn't include here but you can clearly see it is what I am looking for.
Ideally, I just want the formula to return True/False (has weird characters / doesn't have weird characters)
Ses expériences avant de devenir acteur | Jonathan Cohen |
Ahmed Sylla raconte comment il s'est fait virer de l'école
Can You Take Short Hair to New Heights? Discover the Transformation! 💇✨ |
Ink Artistry Gone Wild! 🖋ï¸
Les moments les plus iconiques de Scarlett Johansson ✨ |
How Gossip Girl's cast looks like after 11 years off screen 😱 |
Book1 |
---|
|
---|
| A | B | C |
---|
1 | Text | Has weird character? | |
---|
2 | Ses expériences avant de devenir acteur | Jonathan Cohen | TRUE | |
---|
3 | Ahmed Sylla raconte comment il s'est fait virer de l'école | TRUE | |
---|
4 | Can You Take Short Hair to New Heights? Discover the Transformation! 💇✨ | TRUE | |
---|
5 | Ink Artistry Gone Wild! ðŸ–‹ï¸ | TRUE | |
---|
6 | Les moments les plus iconiques de Scarlett Johansson ✨ | TRUE | |
---|
7 | How Gossip Girl's cast looks like after 11 years off screen 😱 | TRUE | |
---|
8 | abc 123 | FALSE | |
---|
9 | agsf~!@#$%^&*()_+=? | FALSE | |
---|
10 | I attached below some rows I have | FALSE | |
---|
11 | | | |
---|
|
---|
Book1 |
---|
|
---|
| A | B | C |
---|
1 | Text | Has weird character? | |
---|
2 | Ses expériences avant de devenir acteur | Jonathan Cohen | TRUE | |
---|
3 | Ahmed Sylla raconte comment il s'est fait virer de l'école | TRUE | |
---|
4 | Can You Take Short Hair to New Heights? Discover the Transformation! 💇✨ | TRUE | |
---|
5 | Ink Artistry Gone Wild! ðŸ–‹ï¸ | TRUE | |
---|
6 | Les moments les plus iconiques de Scarlett Johansson ✨ | TRUE | |
---|
7 | How Gossip Girl's cast looks like after 11 years off screen 😱 | TRUE | |
---|
8 | abc 123 | FALSE | |
---|
9 | agsf~!@#$%^&*()_+=? | FALSE | |
---|
10 | I attached below some rows I have | FALSE | |
---|
11 | | | |
---|
|
---|
Thank you very much, that worked!