How to find special/weird characters in Excel?

FlashDota

New Member
Joined
Jun 11, 2023
Messages
33
Office Version
  1. 2021
Platform
  1. Windows
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 😱
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Book1
ABC
1TextHas weird character?
2Ses expériences avant de devenir acteur | Jonathan CohenTRUE
3Ahmed Sylla raconte comment il s'est fait virer de l'écoleTRUE
4Can You Take Short Hair to New Heights? Discover the Transformation! 💇✨TRUE
5Ink Artistry Gone Wild! 🖋ï¸TRUE
6Les moments les plus iconiques de Scarlett Johansson ✨TRUE
7How Gossip Girl's cast looks like after 11 years off screen 😱TRUE
8abc 123FALSE
9agsf~!@#$%^&*()_+=?FALSE
10I attached below some rows I haveFALSE
11
Sheet2
Cell Formulas
RangeFormula
B2:B10B2=SUM(--(CODE(MID(A2,SEQUENCE(LEN(A2)),1))>126))>0
 
Upvote 0
Solution
Book1
ABC
1TextHas weird character?
2Ses expériences avant de devenir acteur | Jonathan CohenTRUE
3Ahmed Sylla raconte comment il s'est fait virer de l'écoleTRUE
4Can You Take Short Hair to New Heights? Discover the Transformation! 💇✨TRUE
5Ink Artistry Gone Wild! 🖋ï¸TRUE
6Les moments les plus iconiques de Scarlett Johansson ✨TRUE
7How Gossip Girl's cast looks like after 11 years off screen 😱TRUE
8abc 123FALSE
9agsf~!@#$%^&*()_+=?FALSE
10I attached below some rows I haveFALSE
11
Sheet2
Cell Formulas
RangeFormula
B2:B10B2=SUM(--(CODE(MID(A2,SEQUENCE(LEN(A2)),1))>126))>0
Thank you very much, that worked!
 
Upvote 0

Forum statistics

Threads
1,223,883
Messages
6,175,167
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top