Tags » Excel

Make it, Wear it

See, no look of an egg cosy on my gorgeous friend. I knew it!

The slouchy beanie with pom pom is a success. It’s a Birthday present and definitely lives up to the book’s name: Hook, Stitch and Give. 221 more words


What days are the busiest in the Maternity Ward?


This lesson can be used as part of your unit on reproduction, a stand alone lesson to practice collecting and analyzing data, or as part of a math lesson on statistics. 79 more words

Life Science

Excel - How to split a column in 2 or 3

Do you have a column containing a full name, like this:-

….that you’d prefer to have separated into first and last name ?

It’s very simple to separate them using a few steps in Excel. 97 more words

Learning Zone

Fill in Blank Cells with the Values Above in an Excel List [Video]

This video shares a cool trick for Excel lists. Sometimes when you import an Excel file you get blank values that need to be filled in. 16 more words


Count spaces in cell

This function will count spaces in a cell. You can replace the space with any other character, and it will return the of it, in an exact match. 39 more words


Sum digitis in cell number

This udf function will sum all digits in a cell number.

Function sumdigits(text As Range)
Dim i As Integer
Dim oldNumber As String
Dim newNumber As Double…

21 more words