March 20th in Formatting by . no comment .

SPLIT FIRST and LAST NAME

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 …

Continue Reading
November 17th in Formatting by . 1 comment .

Merge Cells in Excel

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

Continue Reading
May 18th in Formatting by . 5 comments .

Conditonal Formatting – Shading Alternate Rows

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.

Continue Reading
Excelbuddy.com Get your excel questions answered in our forum!