Скачать или смотреть LEFT, RIGHT, LOWER, UPPER, PROPER, LEN, TRIM, CONCATENATE

TEXT FUNCTIONS IN EXCEL

Text functions in Excel help you manipulate and manage text strings, such as extracting characters, cleaning up spaces, or joining multiple pieces of text together.

These are particularly useful in data cleaning, name formatting, report generation, and data preparation for analysis.

1. LEFT Function

Purpose:
Extracts a specific number of characters from the left side of a text string.

Syntax:
=LEFT(text, [num_chars])

Arguments:

text – the text string you want to extract from.

num_chars – the number of characters to extract (default is 1).

Example:

=LEFT("Nigeria", 3)
returns "Nig".

Use case:
Extracting prefixes, codes, or the first few letters of names (e.g., first 3 letters of employee IDs).

2. RIGHT Function

Purpose:
Extracts a specific number of characters from the right side of a text string.

Syntax:

=RIGHT(text, [num_chars])

Example

=RIGHT("2025Excel", 5)

Use case:
Useful for extracting endings such as serial numbers, year codes, or last names.

3. LOWER Function

Purpose:
Converts all letters in a text string to lowercase.

Syntax:
=LOWER(text)

Arguments:

text – the text or cell reference you want to convert.

Example:
If cell A2 contains "BANKTRUST PLC",

=LOWER(A2)

returns
banktrust plc

Use Case:
Useful when standardizing text data like email addresses or usernames.

4. UPPER Function

Purpose:
Converts all letters in a text string to uppercase.

Syntax:
=UPPER(text)

Example:
If A2 contains "Banktrust Plc",

=UPPER(A2)

returns
BANKTRUST PLC


Use Case:
Used for codes, account IDs, or headings where text must appear in all caps.

5. PROPER Function

Purpose:
Capitalizes the first letter of each word and converts all other letters to lowercase (also called title case).

Syntax:
=PROPER(text)

Example:
If A2 contains "john ADEYEMI",

=PROPER(A2)

returns
John Adeyemi

Use Case:
Ideal for cleaning up names, city names, or titles imported in inconsistent letter cases.

6. LEN Function

Purpose:
Counts the number of characters in a text string (including spaces).

Syntax:
=LEN(text)

Example

=LEN("Excel 2025")
returns 10.

Use case:
Useful in validating text lengths (e.g., ID numbers, phone numbers) or preparing data for text extraction.

7. TRIM Function

Purpose:
Removes all extra spaces from a text string, leaving only single spaces between words.

Syntax:

=TRIM(text)

Example
=TRIM(" Data Science ")

returns "Data Science".

Use case:
Cleaning up imported data that may contain unnecessary spaces.

8. CONCAT Function

Purpose:
Joins multiple text strings together into one. It replaces the older CONCATENATE function.

Syntax:
=CONCAT(text1, [text2], …)

Example
=CONCAT(A2, " ", B2)

joins the first name in A2 and the last name in B2 with a space between them.

Use case:
Combining data from multiple columns (e.g., first and last names, or city and state).