View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
spirosu
 
Posts: n/a
Default if statements, searching for commma


Does anyone know if there is a way to use the if function to search for
comma's within a cell. For instance, in the below, using the if
function, I've tried the below without success.

if(A1=",","Flag","Unflag")

It's obviously wrong...I'd greatly appreciate if someone can lend me a
hand. Seems simple enough but can't figure it out.


_Column_A__
Row 1 EMERGING MARKETS
Row 2 KINNUNEN, JUHA
Row 3 POSEN, DAVID
Row 4 HORTON, WILLIAM


--
spirosu
------------------------------------------------------------------------
spirosu's Profile: http://www.excelforum.com/member.php...fo&userid=7442
View this thread: http://www.excelforum.com/showthread...hreadid=513762