Re: if statements, searching for commma
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Fri, 17 Feb 2006 12:24:20 -0600
=if(isnumber(search(",",a1)),"flag","unflag")
or
=if(countif(a1,"*,*")>0,"flag","unflag")
spirosu wrote:
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?action=getinfo&userid=7442
View this thread: http://www.excelforum.com/showthread.php?threadid=513762
--
Dave Peterson
.
- Follow-Ups:
- Re: if statements, searching for commma
- From: spirosu
- Re: if statements, searching for commma
- References:
- if statements, searching for commma
- From: spirosu
- if statements, searching for commma
- Prev by Date: Re: Browse File for Mac
- Next by Date: Re: Preventing errors
- Previous by thread: Re: if statements, searching for commma
- Next by thread: Re: if statements, searching for commma
- Index(es):
Relevant Pages
|
