Place an X next to a cell that contains a word

  • Thread starter Thread starter jerredjohnson
  • Start date Start date
J

jerredjohnson

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

How can I do this?

Please help!

Thanks,
Jerre
 
Further Info:
The cells containing words just dont contain one word
 
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
 
=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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

match a word in a cell and copy anoher cell in the same row 1
Search for string containing 5
cell B1 contains a word listed in cell A1 2
Placing word into a seperate cell 9
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
adding cells that contain a formula 3
VBA set thick borders around non empty cells in range 0
Excel Sum numbers in cells that also contain text 34

Back
Top