Split First & Last name The following formula is useful when you have one cell containing text which needs to be split up. One of the most common examples of this is when a person’s Forename and Surname are entered in full into a cell. The formula uses various text …

Merging cells in an Excel spreadsheet is extremely useful. By merging cells, you can greatly enhance the look and feel of a spreadsheet.

This Excel function is very useful when dealing with long lists of data. However, it is extremely easy to use once you know the simple formula.