Using text functions (reference)

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. Introduction to using text functions (reference) This post will teach you how to use each of the text functions (reference) and some important factors toContinue reading “Using text functions (reference)”

How to combine text and numbers?

Applies to: Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007. This post will teach you how to combine numbers and text using various functions, including CONCATENATE, CONCAT, TEXT and TEXTJOIN functions. Imagine you must make a grammatically correct sentence from numerous columns of data to finalise a widespread mailing. Alternatively, you’re in need ofContinue reading “How to combine text and numbers?”

How to count characters in cells

Applies to: Excel for Microsoft 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013. In this post you will learn how to count characters in cells, using the LEN function and SUM function. Counting characters using the LEN Function For any time you have to count the characters in cells, the LEN function comes in handy. This functionContinue reading “How to count characters in cells”

How to use the SEARCH and SEARCHB Functions?

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. This post will show you how to use the SEARCH and SEARCHB functions in Microsoft Excel. We will will cover their descriptions, their respective formulaContinue reading “How to use the SEARCH and SEARCHB Functions?”

How to use FIND and FINDB Functions?

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.  This post will teach you how to use the FIND and FINDB functions in Microsoft Excel. You will learn how they work, the syntax ofContinue reading “How to use FIND and FINDB Functions?”

How to use the CONCAT Function?

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2019 for Mac. This post will teach you how to use the CONCAT function (how it is formatted), essential conditions for it to work, some examples. There will also be some further links directing you to similar topics to exploreContinue reading “How to use the CONCAT Function?”

Using the CONCATENATE Function

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. This post will teach you how to use the CONCATENATE function in Excel. We will cover what it is used for, its syntax, examples whichContinue reading “Using the CONCATENATE Function”

How to use the TRIM Function?

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. In this post, we will explore how to use the TRIM function in Excel, including a summary of it, its syntax, and also an exampleContinue reading “How to use the TRIM Function?”

How do the RIGHT and RIGHTB Functions work?

Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010.  This post will teach you how the RIGHT and RIGHTB functions work in Microsoft Excel. It will outline their descriptions and syntaxes along with an example you can test to putContinue reading “How do the RIGHT and RIGHTB Functions work?”

How to use LEFT, LEFTB functions

Applies to: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2019, Excel 2016, Excel 2019 for Mac, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Starter 2010. This post will teach you how to use the LEFT/LEFTB functions in Microsoft Excel. It includes its description, syntax and example for you to experiment with atContinue reading “How to use LEFT, LEFTB functions”