FUNCTIONS CONCATENATE, EXACT & TRIM

CONCATENATE

This function joins various text strings into one text string.

How does it work?

If cell A1, B1 and C1 have different text string (or where ever) “FC”, “24” and “G03” respectively, and you want to join these three text strings… apply the following formula in D1 (or anywhere)

=CONCATENATE(A1,B1,C1)
This will return one text string “FC24G03” in the cell.

You can also give the “Text_Itself” instead of cell reference in the formula.

=CONCATENATE(“FC”,”24”,”G03”)

Note: “&” sign can also be used in between cell references or text strings instead of comma “,”


EXACT

This function compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise.
EXACT is case-sensitive but ignores formatting differences.

How does it work?

=EXACT(A1,B1)
This will compare the text in cell A1 with the cell in B1 and returns TRUE if they are exactly the same.


TRIM

This function removes all spaces from text except for single spaces between words.
Use TRIM on text that you have received from another application that may have irregular spacing.
How does it work?

Apply the following formula giving the cell reference of the text.

=TRIM(A1)