Scribd
Upload
11 views1 page

ALX Text Functions Reference Card 3709

This document provides a reference card for various text functions in spreadsheet applications, including SUBSTITUTE, UPPER, LOWER, PROPER, TRIM, CLEAN, SEARCH, FIND, SPLIT, and CONCATENATE. Each function is accompanied by a brief description and an example of its usage. The functions are designed to manipulate and analyze text data efficiently.

Uploaded by

Ssaed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views1 page

ALX Text Functions Reference Card 3709

This document provides a reference card for various text functions in spreadsheet applications, including SUBSTITUTE, UPPER, LOWER, PROPER, TRIM, CLEAN, SEARCH, FIND, SPLIT, and CONCATENATE. Each function is accompanied by a brief description and an example of its usage. The functions are designed to manipulate and analyze text data efficiently.

Uploaded by

Ssaed
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Reference card

Text edit
Text functions
SUBSTITUTE
Used to replace a specific character or string of characters in a cell with a
different character or string.
Text case
=SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
UPPER
Used to convert a specified string to uppercase. Ex. =SUBSTITUTE(“Google”, "ogle", "od") → “Good”

=UPPER(text) TRIM
Used to remove leading, trailing, and repeated spaces in text.
Ex. =UPPER(“hello world”) → “HELLO WORLD”

=TRIM(text)
LOWER
Used to convert a specified string to lowercase. Ex. =TRIM(" Hello, World! ") → “Hello, World!”

=LOWER(text) CLEAN
Used to remove non-printable ASCII characters from a text.
Ex. =LOWER(“HELLO WORLD”) → “hello world”

=CLEAN(text)
PROPER
Used to capitalise each word in a specified string. Ex. =CLEAN("Hello World!") → “HelloWorld”

=PROPER(text_to_capitalise) SPLIT
Used to divide text around a specified character or string. Each resulting
Ex. =PROPER(“hello WORLD”) → “Hello World” fragment is then put into a separate cell in the row.

Text search/find =SPLIT(text, delimiter, [split_by_each], [remove_empty_text])

SEARCH Ex. SPLIT("1,2,3", ",") → 1 2 3

Used to return the position at which a string is first found within text.
The SEARCH function is not case sensitive. CONCATENATE
Used to append strings to one another.
=SEARCH(search_for, text_to_search, [starting_at])
=CONCATENATE(string1, [string2, ...])
Ex. =SEARCH("World", "Hello, World!") → 8
Ex. =CONCATENATE("Hello", " ", "World!") -> “Hello World!”
FIND
Used to return the position at which a string is first found within text.
The FIND function is case sensitive.

=FIND(search_for, text_to_search, [starting_at])

Ex. =FIND("World", "Hello, world!") -> #VALUE!

You might also like