These operations are especially useful in formulas where you're using the IF function or similar functions like the SUMIF ... Excel 2003 is a powerful tool that... How to Delete a Row if Text ...

Excel's INDIRECT function turns a text string into a reference ... In this example, typing =SUM(INDIRECT(A2)) into cell B2 first turns A2 into a cell reference, and then sums the cells in that ...

Most of us stick to the popular Excel functions like SUM and VLOOKUP ... The syntax for TEXTSPLIT is: Here, text is the ...