Learn how to calculate all the particulars of a loan using Excel and how to set up a schedule of repayment for a mortgage or any other loan.

The MID and MIDB functions in Excel return a specific number of characters from a text string starting at the position you specify.