Scribd
Upload
10 views

Text Functions - Reference Card - Final 3709

Uploaded by

Kareem El Molla
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
10 views

Text Functions - Reference Card - Final 3709

Uploaded by

Kareem El Molla
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 functions
Text edit
SUBSTITUTE
Text case Used to replace a specific character or string of characters in a cell with a
different character or string.
UPPER
=SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
Used to convert a specified string to uppercase.

Ex. =SUBSTITUTE(“Google”, "ogle", "od") → “Good”


=UPPER(text)

Ex. =UPPER(“hello world”) → “HELLO WORLD” TRIM


Used to remove leading, trailing, and repeated spaces in text.
LOWER
=TRIM(text)
Used to convert a specified string to lowercase.

Ex. =TRIM(" Hello, World! ") → “Hello, World!”


=LOWER(text)

Ex. =LOWER(“HELLO WORLD”) → “hello world” CLEAN


Used to remove non-printable ASCII characters from a text.
PROPER
=CLEAN(text)
Used to capitalise each word in a specified string.

Ex. =CLEAN("Hello World!") → “HelloWorld”


=PROPER(text_to_capitalise)

Ex. =PROPER(“hello WORLD”) → “Hello World” SPLIT


Used to divide text around a specified character or string. Each resulting fragment
Text search/find is then put into a separate cell in the row.

=SPLIT(text, delimiter, [split_by_each], [remove_empty_text])


SEARCH
Used to return the position at which a string is first found within text. Ex. SPLIT("1,2,3", ",") → 1 2 3
The SEARCH function is not case sensitive.

=SEARCH(search_for, text_to_search, [starting_at])


CONCATENATE
Used to append strings to one another.
Ex. =SEARCH("World", "Hello, World!") → 8
=CONCATENATE(string1, [string2, ...])
FIND
Ex. =CONCATENATE("Hello", " ", "World!") -> “Hello World!”
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