Place an X next to a cell that contains a word

[jerredjohnson]

I have a column that has words in each cell. I want to search through the column and for any cell containing the word 'base' i want to place an X in the cell next to it.

How can I do this?

Please help!

Thanks,
Jerred

[jerredjohnson]

Further Info:
The cells containing words just dont contain one word

[Elkar]

Let's say your column of data is Column A. In Column B enter the formula:

=IF(ISERROR(SEARCH("base",A1)),"","X")

Copy the formula down Column B as needed.

HTH,
Elkar


"jerredjohnson" wrote:

>
> I have a column that has words in each cell. I want to search through
> the column and for any cell containing the word 'base' i want to place
> an X in the cell next to it.
>
> How can I do this?
>
> Please help!
>
> Thanks,
> Jerred
>
>
> --
> jerredjohnson
> ------------------------------------------------------------------------
> jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236
> View this thread: http://www.excelforum.com/showthread...hreadid=550489
>
>

[jerredjohnson]

My hat off to you, thanks!

[paul]

=IF(ISERROR(SEARCH("base",D15,1)),"","x").
replace the d15 with the first reference to search and copy down
in my lttle test,base,scott base,baseball returned an x ,a blank cell or a
cell with no base remained Blank

--
paul
[email protected]
remove nospam for email addy!



"jerredjohnson" wrote:

>
> Further Info:
> The cells containing words just dont contain one word
>
>
> --
> jerredjohnson
> ------------------------------------------------------------------------
> jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236
> View this thread: http://www.excelforum.com/showthread...hreadid=550489
>
>

[Dave Peterson]

One more:

=if(countif(a1,"*" & "Base" & "*")=0,"","X")
or
=if(countif(a1,"*Base*")=0,"","X")
or
=if(countif(a1,"*" & C999 & "*")=0,"","X")
if c999 holds the word Base.

jerredjohnson wrote:
>
> I have a column that has words in each cell. I want to search through
> the column and for any cell containing the word 'base' i want to place
> an X in the cell next to it.
>
> How can I do this?
>
> Please help!
>
> Thanks,
> Jerred
>
> --
> jerredjohnson
> ------------------------------------------------------------------------
> jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236
> View this thread: http://www.excelforum.com/showthread...hreadid=550489

--

Dave Peterson