Dave Bruns

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?"...

This video reviews the key operators you can use in an Excel formula to perform math or build a logical expression.

Most Excel functions require arguments. In this video, we explain how function arguments work and how to use them.