+ Reply to Thread
Results 1 to 7 of 7

Finding special character in a string

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Finding special character in a string

    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

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Finding special character in a string

    try thi (comfirmed with ctrl+shift+enter)

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    change blue reference to other cell
    Last edited by zbor; 07-01-2013 at 04:55 AM.

  3. #3
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Re: Finding special character in a string

    This formula is not working out properly.

  4. #4
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Finding special character in a string

    Why not???

  5. #5
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Re: Finding special character in a string

    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.

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Finding special character in a string

    Check here and tell what is not working
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    07-17-2012
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    461

    Re: Finding special character in a string

    Thank You. Now it is working exactly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1