You can also use the Right function, where you tell Excel to delete the numbers on the left and keep the numbers on the right.

There are two other methods to use the Row function. Method one is to click the fx button on the top left of the Excel worksheet. An Insert Function dialog box will appear.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.