Mastering Excel Through Projects by Hong Zhou

Author:Hong Zhou
Language: eng
Format: epub
ISBN: 9781484278420
Publisher: Apress

Functions to Learn

We need to learn several new functions in this chapter, including CONCATENATE, LEN, MOD, QUOTIENT, GCD, INT, and COUNTIF.

CONCATENATE and the & Operator

The function CONCATENATE combines multiple text strings together as one text string. Its syntax is CONCATENATE(text1, [text2], ...), which indicates it can have one or more arguments. For example, the formula =CONCATENATE("Good", "Morning") generates a string “GoodMorning.” If we want to have a space between the two words, we must explicitly add a space between. For example, we can revise our formula to be =CONCATENATE("Good", " ", "Morning").

Sometimes, people do not use the CONCATENATE function; instead, they use the operator & to combine text strings together. Assume cells A1 and B1 have the words Good and Morning, respectively; we can then write the formula =A1 & " " & B1 to combine the two words and leave a space between them.

In fact, the operator & is used more often than the function CONCATENATE.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.