Evaluate your level with the IF, IFS and IFERROR functions Series of questions to learn the functions IF, IFS and IFERROR. They are very useful to manage condition in your workbook.
Position of a character in a string with SEARCH function The SEARCH function is very useful when you don't know the position of a character in a string. Look at the example in this page to see how using it.