Character  
Author Message
VMCspam





PostPosted: Wed Nov 14 07:09:00 PST 2007 Top

worksheet functions >> Character

Hello,

I would like cell B1 to reference cell A1, and if cell A1 contains a "N"
within the cells text (multiple characters) then I would like cell B1 to give
a particular phrase otherwise give other text.

Thanks,

Excel112  
 
 
PhilipJSmith





PostPosted: Wed Nov 14 07:09:00 PST 2007 Top

worksheet functions >> Character Hi tjh

Use the =FIND function nested within an =IF function.

Your check within the IF function should look for an #N/A return from the
FIND function.

Excel's help or textbooks should explain these well.

Regards

Phil



> Hello,
>
> I would like cell B1 to reference cell A1, and if cell A1 contains a "N"
> within the cells text (multiple characters) then I would like cell B1 to give
> a particular phrase otherwise give other text.
>
> Thanks,
 
 
Bob





PostPosted: Wed Nov 14 07:11:12 PST 2007 Top

worksheet functions >> Character =IF(ISNUMBER(SEARCH("N",A1)),"phrase 1","phrase2 ")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



> Hello,
>
> I would like cell B1 to reference cell A1, and if cell A1 contains a "N"
> within the cells text (multiple characters) then I would like cell B1 to
> give
> a particular phrase otherwise give other text.
>
> Thanks,


 
 
Dave





PostPosted: Wed Nov 14 07:13:21 PST 2007 Top

worksheet functions >> Character =if(countif(a1,"*N*")>0,"it's there","it's not there")
or
=if(isnumber(search("n",a1)),"it's there","it's not there")
or
=if(isnumber(Find("N",a1)),"it's there","it's not there")

=find() is case sensitive.
=search() is not case sensitive.
The =countif() is not case sensitive, too.


>
> Hello,
>
> I would like cell B1 to reference cell A1, and if cell A1 contains a "N"
> within the cells text (multiple characters) then I would like cell B1 to give
> a particular phrase otherwise give other text.
>
> Thanks,

--

Dave Peterson
 
 
tjh





PostPosted: Wed Nov 14 07:19:04 PST 2007 Top

worksheet functions >> Character Is this what you mean? I get a Value error with this. Not sure what I am
doing wrong.
=IF(ISNA(FIND("N",A1)),"NO N",FIND("N",A1))

Thanks,




> Hi tjh
>
> Use the =FIND function nested within an =IF function.
>
> Your check within the IF function should look for an #N/A return from the
> FIND function.
>
> Excel's help or textbooks should explain these well.
>
> Regards
>
> Phil
>

>
> > Hello,
> >
> > I would like cell B1 to reference cell A1, and if cell A1 contains a "N"
> > within the cells text (multiple characters) then I would like cell B1 to give
> > a particular phrase otherwise give other text.
> >
> > Thanks,
 
 
PhilipJSmith





PostPosted: Wed Nov 14 08:02:01 PST 2007 Top

worksheet functions >> Character Apologies I should have suggested checking for #Value! rather than #N/A!

=IF(ISERR(FIND("N",UPPER(A1))),"No N","N")

I've also added UPPER, this will find "n" and "N".

Regards

Phil




> Is this what you mean? I get a Value error with this. Not sure what I am
> doing wrong.
> =IF(ISNA(FIND("N",A1)),"NO N",FIND("N",A1))
>
> Thanks,
>
>

>
> > Hi tjh
> >
> > Use the =FIND function nested within an =IF function.
> >
> > Your check within the IF function should look for an #N/A return from the
> > FIND function.
> >
> > Excel's help or textbooks should explain these well.
> >
> > Regards
> >
> > Phil
> >

> >
> > > Hello,
> > >
> > > I would like cell B1 to reference cell A1, and if cell A1 contains a "N"
> > > within the cells text (multiple characters) then I would like cell B1 to give
> > > a particular phrase otherwise give other text.
> > >
> > > Thanks,