Excel has many functions to offer when it comes to manipulating text strings. The following is the list regarding to the arrangement of text.
Without Array Formula | With Array Formula | F9 Key | Count Errors | Count Unique Values | Count with Or Criteria | Sum with Or...
##### error | #NAME? error | #VALUE! error | #DIV/0! error | #REF! error This chapter teaches you how to deal with some...
Round | RoundUp | RoundDown | Even and Odd | Nearest Multiple This chapter illustrates three functions to round numbers in...
Average | Averageif | Median | Mode | Standard Deviation | Min | Max | Large | Small This chapter gives...
Pmt | Rate | Nper | Pv | Fv To illustrate Excel's most popular financial functions, we consider a loan with monthly...
