AST - Text Functions Lesson

Text Functions Lesson

Introduction

When most people think of spreadsheet software like Excel, they usually think about performing numerical data calculations. It’s partially true, as Excel mostly specializes in numerical functions. However, Excel also has several incredibly useful functions for working with text data.

This lesson contains an overview of Excel functions for working with text data.

Other Excel Text Functions

Here are several additional Excel text functions that you may want to try out on your own:

Function	Description
CLEAN	Removes all non-printable characters from a supplied text string.
TRIM	Removes duplicate spaces, and spaces at the start and end of a text string.
CODE	Returns the numeric code for the first character of a supplied string.
UNICODE	Returns the number (code point) corresponding to the first character of a supplied text string.
CHAR	Returns the character that corresponds to a supplied numeric value.
UNICHAR	Returns the Unicode character that is referenced by the given numeric value.
REPT	Returns a string consisting of a supplied text string, repeated a specified number of times.
TEXTJOIN	Joins together two or more text strings, separated by a delimiter.
LEN	Returns the length of a supplied text string.
FIND	Returns the position of a supplied character or text string from within a supplied text string (case-sensitive).
SEARCH	Returns the position of a supplied character or text string from within a supplied text string (non-case-sensitive).
EXACT	Tests if two supplied text strings are exactly the same and if so, returns TRUE; Otherwise, returns FALSE. (case-sensitive)
T	Tests whether a supplied value is text and if so, returns the supplied text; If not, returns an empty text string.
REPLACE	Replaces all or part of a text string with another string (from a user supplied position).
SUBSTITUTE	Substitutes all occurrences of a search text string, within an original text string, with the supplied replacement text.

IMAGES CREATED BY GAVS