Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Contents
How do I set up a formula so that if a cell contains certain txt, then the
cell I'm in will display certain text? For Example, I'm entering the formula in C5, if B5 contains the word "Assembly" anywhere in it, then I want C5 to say Assembly, otherwise I want it to copy B5. Any help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Contents
=if(countif(b5,"*"&"assembly"&"*")0,"Assembly",b5 )
or =if(isnumber(search("assembly",b5)),"Assembly",b5) =search() ignores upper/lower case. Use =Find() if case is important. (=countif() ignores case, too.) lightbulb wrote: How do I set up a formula so that if a cell contains certain txt, then the cell I'm in will display certain text? For Example, I'm entering the formula in C5, if B5 contains the word "Assembly" anywhere in it, then I want C5 to say Assembly, otherwise I want it to copy B5. Any help? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) |