The Undergraduate Advising Office is here to help you find answers. Our advisors have prepared a list of Frequently Asked Questions about courses and credits. If you don't find an answer to your question there, please contact the advising office by emailing bioadv@indiana.edu or calling (812) 855-3810.he Undergraduate Advising Office is here to help you find answers. Our advisors have prepared a list of Frequently Asked Questions about courses and credits. If you don't find an answer to your question there, please contact the advising office by emailing bioadv@indiana.edu or calling (812) 855-3810.
If a cell contains a specific text than return a value Everywhere I search I see this formula for looking in a column and if a row contains a specific value then to return x, if not return y. =IF(ISNUMBER(SEARCH(text, A1)),X,Y) But when I use this in Excel 2010 I get an error. I modify it to look like this...
The cell is set for Wrap Text, but the text isnât being displayed. In this case, widening the column doesnât fix the problem â youâll just end up with a wider column of number signs. For text cells that are showing number signs, set the cell format to General, instead of Text. Itâs a strange solution, because Text seems like the logical choice, when formatting a cell that contains text. Here is the same cell, with General format. The good news is that this problem seems to be fixed in Excel 2010.