Finding special character in a string

**sathishkm** · 07-01-2013, 04:40 AM

Hi All,

I have to find the special characters in a cell. Is there any formula to do so? I need to find the only the special characters. The cell may contain numbers and alphabets. In those case it should return true. Only when it contains the special characters, it should return false.

Example:-

U72900T-NDBBBD SHOULD RETURN FALSE
334DGDGHFHFDH SHOULD RETURN TRUE

**zbor** · 07-01-2013, 04:51 AM

try thi (comfirmed with ctrl+shift+enter)

Formula:

Please Login or Register  to view this content.

change blue reference to other cell

**sathishkm** · 07-01-2013, 05:32 AM

This formula is not working out properly.

**zbor** · 07-01-2013, 05:42 AM

Why not???

**sathishkm** · 07-01-2013, 05:52 AM

I have 10K numbers like this from cell A1 to A10000. In this column I have to find the cell which is having the special characters.

**zbor** · 07-01-2013, 05:57 AM

Check here and tell what is not working

**sathishkm** · 07-01-2013, 06:10 AM

Thank You. Now it is working exactly.

Finding special character in a string

LinkBack

Thread Tools

Rate This Thread

Display

Finding special character in a string

Re: Finding special character in a string

Re: Finding special character in a string

Re: Finding special character in a string

Re: Finding special character in a string

Re: Finding special character in a string

Re: Finding special character in a string

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions