Results 1 to 4 of 4

Thread: How to determine if a cell contains a comma

  1. #1

    How to determine if a cell contains a comma



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I would like an equation that can identify if there is a comma in a cell

    For example,

    "red" would return "no", but "red, yellow" would return "yes"

  2. #2
    Sorry, false alarm... figured it out using countifs, unless someon has a better solution.

  3. #3
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    you could use something like

    =IF(IFERROR(SEARCH(",",A1,1)>1,0),"yes","no")

    instead of using search you could also use find. these are similar to using instr() in VBA.

  4. #4
    =IF(ISNUMBER(FIND(",",A1)),"yes","no")

Posting Permissions

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