Results 1 to 3 of 3

Thread: How to find out if there is any special character in Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    21

    How to find out if there is any special character in Excel

    How do I test if a cell has any of the special characters e.g. *,?,/. Thanks

  2. #2
    Join Date
    Jul 2011
    Posts
    440

    Re: How to find out if there is any special character in Excel

    Try the following code and it might provide you some help for the process you are looking for.
    Code:
    Function CellHasSpecChar(c As Range) As Boolean
    CellHasSpecChar = c.Value Like "*[?/*]*"
    End Function
    
    Sub TestIt()
    MsgBox CellHasSpecChar(ActiveCell)
    End Sub

  3. #3
    Join Date
    Aug 2011
    Posts
    566

    Re: How to find out if there is any special character in Excel

    Just s right-click and then click on Edit. Then click on Custom and then you go to insert. Then you seeks special characters and finally you made a deposit slip from the menu insertion. Go look at the word or the special characters you are looking for. You can copy / paste or find out that there is any empty value or not.

Similar Threads

  1. Replies: 2
    Last Post: 07-02-2012, 08:01 PM
  2. How to get special symbols for correct sign in Excel
    By Shaina Na in forum Windows Software
    Replies: 1
    Last Post: 06-01-2012, 06:07 PM
  3. What are the shortcut keys for Special Character
    By Santy in forum Customize Desktop
    Replies: 4
    Last Post: 25-06-2009, 06:55 PM
  4. How to insert special character in mail on MAC OS
    By mathews in forum Operating Systems
    Replies: 3
    Last Post: 24-06-2009, 06:58 PM
  5. Insert a special character in a document (ASCII codes)
    By wingeek in forum Customize Desktop
    Replies: 3
    Last Post: 06-02-2009, 10:46 PM

Tags for this Thread

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
  •  
Page generated in 1,711,718,270.83719 seconds with 17 queries