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...
Note how the numbers in the joined strings (column E) do not adopt the formatting from the source cells (column C). To solve this problem, you have to wrap the cell reference for your number value in the TEXT function. Using the TEXT function, you can apply the needed formatting on the fly. The TEXT function requires two arguments: a value, and a valid Excel format.