How to determine if a cell contains a comma

alderman

alderman

New member
Joined
Jan 23, 2014
Messages
19
Reaction score
0
Points
0
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"
 
Sorry, false alarm... figured it out using countifs, unless someon has a better solution.
 
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.
 
You must log in or register to reply here.
Back
Top