<
<

Find Special Char

>

Filter special characters like %^&@.

>

Input

Output

43 Related tools

Table Statistic?

Any Questions?

Filter special characters like %^&@. Special characters are symbols or characters that are not alphabet letters or numbers. Read more about special character on Wikipedia https://en.wikipedia.org/wiki/List_of_Unicode_characters

"&" is a special character because it is not a alphabet letter or a number.

This tool is useful when you need to find data points with special letters, such as searching for email addresses in a list of contacts or filtering out entries with special formatting in a text document.

  • Microsoft Excel: -
  • Google Sheets: -
  • Apple Numbers: -
  • Python Pandas: df[df['column'].apply(is_special_char)]
  • Related Words: special letters, symbols, punctuation, non-alphanumeric

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.

Related Tools?

Add Punctuation

Appends punctuation to the end of sentence like "cat.".

special character
Remove Punctuation

Deletes "." from data.

special character
Remove Exclamation Mark

Deletes '!' from data.

special character
Remove Question Mark

Deletes '?' from data.

special character
Remove Comma

Deletes ',' from data.

special character
Remove Special Character

Deletes values like %^&@.

special character
Extract Special Characters

Extracts special letters from cell like "%^&@".

special character
Find Text

Filter any specific text you want.

Find Number

Filter numerals like 1, 2, 3.

Find Date

Filter values like yyyy-mm-dd or dd-mm-yyyy.

Find Lower Case

Filter small letters like abc.

Find Upper Case

Filter capital letters like ABC.

Find Proper Case

Filter text that are written like "Next Object".

Find Camel Case

Filter text that are written like "nextObject".

Find Snake Case

Filter text that are written like "next_object".

Find Pascal Case

Filter text that are written like "NextObject".

Find Hyphen Case

Filter text that are written like "hext-object".

Find Larger Than Number

Filter numbers like x < 2.

Find Smaller Than Number

Filter numbers like 2 < x.

Find Between Numbers

Filter numbers like 2 < x < 7.

Find Negative Number

Filter numbers like x < 0.

Find Positive Number

Filter numbers like 0 < x.

Find Zero

Filter 0 in your table.

Find Leading Space

Filter values with leading white spaces like " cat".

Find Trailing Space

Filter values with ending white spaces "cat ".

Find Leading Trailing Space

Filter values with leading or trailing spaces like " cat ".

Find Prefix

Filter values with a specific starting word like "co-".

Find Suffix

Filter values with a specific ending word like "tion".

Find Blank

Filter empty cells.

Find Non Blank

Filter non-empty cells.

Find Error

Filter error values like "#REF!".

Find Non Breaking Space

Filters an invisible space that prevents text wraping.

Find Accent

Filter accent characters like äüö.

Find Repeating Text

Filter consecutive occurrences of specific text.

Find Text Of Length

Filter values of a specific length.

Find Alphabet

Filter values with a-z and A-Z.

Find Hyperlink

Filter links like "https://" or "www".

Find Decimal Number

Filter decimal numbers like 2.7.

Find Odd Number

Filter numbers not divisible by 2.

Find Even Number

Filter numbers divisible by 2.

Find Divisible Number

Filter numbers divisible by your specified value.

Find Fibonacci Number

Filter numbers appearing in the fibonacci sequence.

Find Prime Number

Filter numbers divisible only by 1 and itself.

<
👉... other 321 tools to save you time
>