Jan 24 2009

Separate Full Name into First & Last Name

Here are two easy formulas that will separate a cell that contains a full name (first and last name format) into 2 cells – one containing the first name and the other containing the last name.  To do this we are going to make use of the left, right, len & find formulas.

Jun 26 2007

Excel Length Formula

The Excel Length formula is a useful formula that can be used in many different circumstances. I’ll be showing a few of the useful examples of it below. But first let’s take a look at the formula itself: LEN(text) where text is any string you want to find the length of. This formula is really […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks