Dave Bruns

In this video we look at how to use the LEN function to calculate the number of characters in a text string. LEN is a surprisingly useful function that appears in many formulas.

In this video we look at how to combine the FIND function with the LEFT function to extract the first name from a full name using a formula.

In this video we look at how to use the RIGHT and LEFT functions to extract one or more characters from the beginning or end of a string.

In this video we look at how to use the FIND and SEARCH function to find the position of a substring in another string.

In this video we'll look at how to use the CONCATENATE function, an alternative to using the ampersand (&) character to join values in a formula. ...

In this video we look at how to use the TEXT function. The TEXT function is useful when you need to CONCATENATE a number with text using a specific number format.

In this video we look at how to use the operator for concatenation, the ampersand character, to join values together in a formula.

Each character you see displayed in Excel has a number. In this video we look at two functions that work with these numbers directly: CODE and CHAR.

In this video we look at how to use the REPT function, a special function for repeating text values with a numeric counter.

Excel treats numbers and text differently. In this video we answer the question: "What is text in Excel?"...