Suppose you are working with OpenOffice Calc which requires lot of filters. And you want to replace a cell value with a digit to some text or value in another column. If this is the situation, then you can use a combination of IF() and ISNUMBER() to accomplish this task.