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
- Comments Off
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 […]