How To Compare Text In Two Cells In Excel?

Comparing text within two cells in Excel is a common task, and there are several methods to achieve this. COMPARE.EDU.VN provides detailed comparisons and solutions to help you determine if one cell’s text is contained within another, offering various functions and formulas for effective text analysis. Explore different Excel features to accurately compare text, ensuring you make informed decisions with our comprehensive guides.

1. Understanding the Basics of Text Comparison in Excel

Comparing text in Excel is an essential skill for data analysis, cleaning, and validation. Whether you are comparing names, addresses, product descriptions, or any other text-based data, Excel offers several functions and formulas to help you determine the similarities and differences between two cells. Before diving into the specific methods, it’s important to understand the basics of text comparison.

1.1 Why Compare Text in Excel?

Text comparison is crucial for various reasons:

Data Validation: Ensure data consistency by comparing entries against a standard.
Data Cleaning: Identify and correct discrepancies in datasets.
Information Retrieval: Locate specific information within large text strings.
Decision Making: Compare and contrast text-based attributes for better decision-making.

1.2 Basic Concepts

Before we proceed, let’s clarify a few essential concepts:

Case Sensitivity: Whether the comparison differentiates between upper and lower-case letters (e.g., “Apple” vs. “apple”).
Exact Match: An identical match, including spacing and punctuation.
Partial Match: Determining if one text string is contained within another.
Wildcards: Special characters used to represent unknown characters in a text string.

2. Using the EXACT Function for Case-Sensitive Comparisons

The EXACT function in Excel provides a simple way to perform case-sensitive comparisons between two text strings. This function is particularly useful when you need to ensure that the text in two cells is precisely the same, including capitalization.

2.1 Syntax of the EXACT Function

The syntax for the EXACT function is straightforward:

=EXACT(text1, text2)

text1: The first text string to compare.
text2: The second text string to compare.

2.2 How to Use the EXACT Function

Here’s how to use the EXACT function in Excel:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to compare.
Select a Cell: Choose an empty cell where you want the result of the comparison to appear.
Enter the Formula: Type the EXACT function into the selected cell, providing the cell references for the two text strings you want to compare. For example:

=EXACT(A1, B1)

In this formula, A1 and B1 are the cells containing the text you want to compare.

Press Enter: Press the Enter key to execute the formula. The cell will display TRUE if the text in A1 and B1 is exactly the same (including case), and FALSE if they are different.

2.3 Examples of Using the EXACT Function

Let’s look at a few examples to illustrate how the EXACT function works:

Cell A1	Cell B1	Formula	Result
Apple	Apple	`=EXACT(A1, B1)`	TRUE
Apple	apple	`=EXACT(A1, B1)`	FALSE
Apple	Apple	`=EXACT(A1, B1)`	FALSE
Apple Inc	Apple Inc	`=EXACT(A1, B1)`	TRUE
Apple Inc	Apple.Inc	`=EXACT(A1, B1)`	FALSE

2.4 Advantages of Using the EXACT Function

Case-Sensitive: Ensures that the comparison is case-sensitive, which is critical in many scenarios.
Simple Syntax: Easy to understand and use.
Reliable: Provides accurate results for exact matches.

2.5 Limitations of the EXACT Function

Exact Match Only: Only works for exact matches and does not support partial matches.
No Wildcard Support: Does not support the use of wildcards for more flexible comparisons.

2.6 Practical Applications of EXACT Function

The EXACT function is useful in scenarios such as:

Verifying User Input: Checking if a user has entered the correct case-sensitive password or ID.
Comparing Database Records: Ensuring that records from different databases match exactly.
Validating Data Imports: Checking if data imported from external sources is consistent.

3. Using the IF Function for Conditional Text Comparisons

The IF function in Excel is a versatile tool that allows you to perform conditional comparisons between text strings. You can use it to check if two cells are equal and return different results based on whether the condition is true or false.

3.1 Syntax of the IF Function

The syntax for the IF function is as follows:

=IF(logical_test, value_if_true, value_if_false)

logical_test: The condition you want to evaluate (e.g., A1=B1).
value_if_true: The value to return if the condition is true.
value_if_false: The value to return if the condition is false.

3.2 How to Use the IF Function for Text Comparisons

Here’s how to use the IF function to compare text in Excel:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to compare.
Select a Cell: Choose an empty cell where you want the result of the comparison to appear.
Enter the Formula: Type the IF function into the selected cell, specifying the comparison and the values to return. For example:

=IF(A1=B1, "Match", "No Match")

In this formula, A1 and B1 are the cells containing the text you want to compare. If the text in A1 is equal to the text in B1, the formula will return “Match”; otherwise, it will return “No Match”.

Press Enter: Press the Enter key to execute the formula. The cell will display the appropriate result based on the comparison.

3.3 Examples of Using the IF Function

Let’s look at a few examples to illustrate how the IF function works for text comparisons:

Cell A1	Cell B1	Formula	Result
Apple	Apple	`=IF(A1=B1, "Match", "No Match")`	Match
Apple	apple	`=IF(A1=B1, "Match", "No Match")`	No Match
Apple	Apple	`=IF(A1=B1, "Match", "No Match")`	No Match
Apple Inc	Apple Inc	`=IF(A1=B1, "Match", "No Match")`	Match
Apple Inc	Apple.Inc	`=IF(A1=B1, "Match", "No Match")`	No Match

3.4 Combining IF and EXACT for Case-Sensitive Comparisons

To perform case-sensitive comparisons using the IF function, you can combine it with the EXACT function:

=IF(EXACT(A1, B1), "Exact Match", "No Match")

This formula will return “Exact Match” only if the text in A1 and B1 is exactly the same, including case; otherwise, it will return “No Match”.

3.5 Advantages of Using the IF Function

Conditional Logic: Allows for conditional comparisons, providing different results based on the outcome.
Customizable: You can customize the values returned for true and false conditions.
Versatile: Can be combined with other functions like EXACT for more specific comparisons.

3.6 Limitations of the IF Function

Case-Insensitive by Default: The basic IF function is case-insensitive; you need to combine it with EXACT for case-sensitive comparisons.
Exact Match Only: By itself, it only works for exact matches and does not support partial matches.

3.7 Practical Applications of IF Function

The IF function is useful in scenarios such as:

Automated Reporting: Generating reports that highlight discrepancies between expected and actual values.
Data Validation: Automatically flagging data entries that do not match a predefined standard.
Conditional Formatting: Applying different formatting styles to cells based on whether they match a specific text value.

4. Using the FIND and SEARCH Functions for Partial Matches

The FIND and SEARCH functions in Excel are used to locate the position of a substring within a larger text string. These functions are particularly useful for partial match comparisons, where you want to determine if one cell’s text is contained within another.

4.1 Syntax of the FIND and SEARCH Functions

The syntax for the FIND and SEARCH functions is as follows:

=FIND(find_text, within_text, [start_num])
=SEARCH(find_text, within_text, [start_num])

find_text: The text you want to find.
within_text: The text string you want to search within.
[start_num]: (Optional) The character position in within_text at which to start the search. If omitted, the search starts at the first character.

4.2 Key Differences Between FIND and SEARCH

Case Sensitivity: FIND is case-sensitive, while SEARCH is case-insensitive.
Wildcard Support: SEARCH supports wildcard characters (? for any single character and * for any sequence of characters), while FIND does not.

4.3 How to Use the FIND Function for Partial Matches

Here’s how to use the FIND function to check for partial matches in Excel:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to compare.
Select a Cell: Choose an empty cell where you want the result of the comparison to appear.
Enter the Formula: Type the FIND function into the selected cell, specifying the text to find and the text to search within. For example:

=IF(ISNUMBER(FIND(B1, A1)), "Found", "Not Found")

In this formula:

B1 contains the text you want to find.
A1 contains the text you want to search within.
ISNUMBER checks if the FIND function returns a number (the position of the found text). If it does, the formula returns “Found”; otherwise, it returns “Not Found”.

Press Enter: Press the Enter key to execute the formula. The cell will display “Found” if the text in B1 is found within A1, and “Not Found” if it is not.

4.4 How to Use the SEARCH Function for Partial Matches

Here’s how to use the SEARCH function to check for partial matches in Excel:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to compare.
Select a Cell: Choose an empty cell where you want the result of the comparison to appear.
Enter the Formula: Type the SEARCH function into the selected cell, specifying the text to find and the text to search within. For example:

=IF(ISNUMBER(SEARCH(B1, A1)), "Found", "Not Found")

This formula works similarly to the FIND formula, but it is case-insensitive.

Press Enter: Press the Enter key to execute the formula. The cell will display “Found” if the text in B1 is found within A1 (case-insensitive), and “Not Found” if it is not.

4.5 Examples of Using FIND and SEARCH

Let’s look at a few examples to illustrate how the FIND and SEARCH functions work for partial matches:

Cell A1	Cell B1	Formula	Result
The quick brown fox jumps over	quick	`=IF(ISNUMBER(FIND(B1, A1)), "Found", "Not Found")`	Found
The quick brown fox jumps over	Quick	`=IF(ISNUMBER(FIND(B1, A1)), "Found", "Not Found")`	Not Found
The quick brown fox jumps over	Quick	`=IF(ISNUMBER(SEARCH(B1, A1)), "Found", "Not Found")`	Found
The quick brown fox jumps over	lazy dog	`=IF(ISNUMBER(FIND(B1, A1)), "Found", "Not Found")`	Not Found
The quick brown fox jumps over	fox	`=IF(ISNUMBER(SEARCH(B1, A1)), "Found", "Not Found")`	Found

4.6 Advantages of Using FIND and SEARCH

Partial Match: Allows for partial match comparisons, checking if one text string is contained within another.
Case Sensitivity (FIND): FIND provides case-sensitive comparisons.
Case Insensitivity (SEARCH): SEARCH provides case-insensitive comparisons.
Wildcard Support (SEARCH): SEARCH supports wildcard characters for more flexible searches.

4.7 Limitations of FIND and SEARCH

Error Handling: Returns an error if the text is not found, requiring the use of ISNUMBER to handle errors.
Complexity: Can be slightly more complex to use compared to simple equality checks.

4.8 Practical Applications of FIND and SEARCH

The FIND and SEARCH functions are useful in scenarios such as:

Email Filtering: Identifying emails that contain specific keywords.
Content Analysis: Analyzing text data for the presence of certain terms or phrases.
Data Extraction: Extracting relevant information from larger text strings based on keyword searches.

5. Using the LEFT, RIGHT, and MID Functions for Specific Text Extraction

The LEFT, RIGHT, and MID functions in Excel are used to extract specific portions of a text string. These functions are valuable when you need to compare specific segments of text within two cells.

5.1 Syntax of the LEFT, RIGHT, and MID Functions

The syntax for these functions is as follows:

=LEFT(text, [num_chars])
=RIGHT(text, [num_chars])
=MID(text, start_num, num_chars)

text: The text string from which you want to extract characters.
[num_chars]: (Optional for LEFT and RIGHT) The number of characters to extract. If omitted, LEFT and RIGHT extract one character.
start_num: The starting position for extraction (for MID).
num_chars: The number of characters to extract (for MID).

5.2 How to Use the LEFT Function

Here’s how to use the LEFT function to extract text from the beginning of a string:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to extract from.
Select a Cell: Choose an empty cell where you want the extracted text to appear.
Enter the Formula: Type the LEFT function into the selected cell, specifying the text and the number of characters to extract. For example:

=LEFT(A1, 5)

This formula will extract the first 5 characters from the text in cell A1.

Press Enter: Press the Enter key to execute the formula. The cell will display the extracted text.

5.3 How to Use the RIGHT Function

Here’s how to use the RIGHT function to extract text from the end of a string:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to extract from.
Select a Cell: Choose an empty cell where you want the extracted text to appear.
Enter the Formula: Type the RIGHT function into the selected cell, specifying the text and the number of characters to extract. For example:

=RIGHT(A1, 5)

This formula will extract the last 5 characters from the text in cell A1.

Press Enter: Press the Enter key to execute the formula. The cell will display the extracted text.

5.4 How to Use the MID Function

Here’s how to use the MID function to extract text from a specific position within a string:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to extract from.
Select a Cell: Choose an empty cell where you want the extracted text to appear.
Enter the Formula: Type the MID function into the selected cell, specifying the text, the starting position, and the number of characters to extract. For example:

=MID(A1, 3, 5)

This formula will extract 5 characters from the text in cell A1, starting from the 3rd character.

Press Enter: Press the Enter key to execute the formula. The cell will display the extracted text.

5.5 Examples of Using LEFT, RIGHT, and MID

Let’s look at a few examples to illustrate how these functions work:

Cell A1	Formula	Result
Apple Inc	`=LEFT(A1, 5)`	Apple
Apple Inc	`=RIGHT(A1, 3)`	Inc
Apple Inc	`=MID(A1, 3, 3)`	ple
COMPARE.EDU.VN	`=LEFT(A1, 7)`	COMPARE
COMPARE.EDU.VN	`=RIGHT(A1, 3)`	VN
COMPARE.EDU.VN	`=MID(A1, 9, 3)`	EDU

5.6 Combining with IF for Comparisons

You can combine these functions with the IF function to compare specific parts of text strings:

=IF(LEFT(A1, 5)=LEFT(B1, 5), "First 5 chars match", "No match")

This formula checks if the first 5 characters of the text in cell A1 are equal to the first 5 characters of the text in cell B1.

5.7 Advantages of Using LEFT, RIGHT, and MID

Specific Text Extraction: Allows you to extract specific portions of text strings.
Flexible: Can be used to extract text from the beginning, end, or middle of a string.
Combinable: Can be combined with other functions like IF for conditional comparisons.

5.8 Limitations of LEFT, RIGHT, and MID

Requires Knowledge of Text Structure: You need to know the structure of the text to extract the correct portions.
Not Dynamic: If the text structure changes, the formulas may need to be adjusted.

5.9 Practical Applications of LEFT, RIGHT, and MID

The LEFT, RIGHT, and MID functions are useful in scenarios such as:

Data Parsing: Extracting specific data elements from a text string, such as product codes or dates.
String Manipulation: Creating new text strings by combining portions of existing strings.
Data Standardization: Ensuring that data entries conform to a specific format by extracting and reformatting text.

6. Using Wildcard Characters with the SEARCH Function

Wildcard characters provide a flexible way to perform partial match comparisons in Excel. The SEARCH function supports two wildcard characters:

? (question mark): Represents any single character.
* (asterisk): Represents any sequence of characters.

6.1 How to Use Wildcards with SEARCH

Here’s how to use wildcard characters with the SEARCH function:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to compare.
Select a Cell: Choose an empty cell where you want the result of the comparison to appear.
Enter the Formula: Type the SEARCH function into the selected cell, using wildcard characters in the find_text argument. For example:

=IF(ISNUMBER(SEARCH("ap?le", A1)), "Found", "Not Found")

This formula will search for text in cell A1 that starts with “ap”, followed by any single character, and then “le”.

Press Enter: Press the Enter key to execute the formula. The cell will display “Found” if the text matches the pattern, and “Not Found” if it does not.

6.2 Examples of Using Wildcards

Let’s look at a few examples to illustrate how wildcard characters work with the SEARCH function:

Cell A1	Formula	Result
Apple	`=IF(ISNUMBER(SEARCH("ap?le", A1)), "Found", "Not Found")`	Found
Aprle	`=IF(ISNUMBER(SEARCH("ap?le", A1)), "Found", "Not Found")`	Found
Application	`=IF(ISNUMBER(SEARCH("ap*le", A1)), "Found", "Not Found")`	Found
Pineapple	`=IF(ISNUMBER(SEARCH("*le", A1)), "Found", "Not Found")`	Found
COMPARE.EDU.VN	`=IF(ISNUMBER(SEARCH("COMPARE*", A1)), "Found", "Not Found")`	Found

6.3 Practical Use Cases for Wildcards

Finding Variations: Use wildcards to find variations of a word or phrase. For example, searching for “rep?rt” will find both “report” and “repert”.
Locating Patterns: Use wildcards to locate specific patterns in text data. For example, searching for “123-??-####” will find text strings like “123-AB-5678”.
Data Cleaning: Use wildcards to identify and correct inconsistencies in data entries.

6.4 Advantages of Using Wildcards

Flexibility: Provides a flexible way to perform partial match comparisons.
Pattern Matching: Allows you to search for specific patterns in text data.
Case Insensitivity: When used with the SEARCH function, wildcards provide case-insensitive searches.

6.5 Limitations of Using Wildcards

Complexity: Can be more complex to use compared to simple equality checks.
Performance: May be slower for very large datasets.

6.6 Practical Applications of Wildcards

The use of wildcards are useful in scenarios such as:

Searching Customer Data: Finding customer records based on partial name or address information.
Analyzing Log Files: Identifying specific events or errors in log files using pattern matching.
Validating Data Formats: Ensuring that data entries conform to a specific format by using wildcard patterns.

7. Combining Multiple Criteria with AND and OR Functions

When comparing text in Excel, you may need to evaluate multiple criteria simultaneously. The AND and OR functions allow you to combine multiple logical tests into a single condition.

7.1 Syntax of the AND and OR Functions

The syntax for the AND and OR functions is as follows:

=AND(logical1, [logical2], ...)
=OR(logical1, [logical2], ...)

logical1, logical2, …: The logical conditions you want to evaluate.

7.2 How to Use the AND Function

The AND function returns TRUE if all conditions are true, and FALSE otherwise. Here’s how to use it:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to compare.
Select a Cell: Choose an empty cell where you want the result of the comparison to appear.
Enter the Formula: Type the AND function into the selected cell, specifying the conditions you want to evaluate. For example:

=IF(AND(A1="Apple", B1="Inc"), "Apple Inc", "Not Apple Inc")

This formula checks if the text in cell A1 is “Apple” and the text in cell B1 is “Inc”. If both conditions are true, the formula returns “Apple Inc”; otherwise, it returns “Not Apple Inc”.

Press Enter: Press the Enter key to execute the formula. The cell will display the appropriate result based on the conditions.

7.3 How to Use the OR Function

The OR function returns TRUE if at least one condition is true, and FALSE if all conditions are false. Here’s how to use it:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to compare.
Select a Cell: Choose an empty cell where you want the result of the comparison to appear.
Enter the Formula: Type the OR function into the selected cell, specifying the conditions you want to evaluate. For example:

=IF(OR(A1="Apple", B1="Apple"), "Apple Found", "Apple Not Found")

This formula checks if the text in cell A1 is “Apple” or the text in cell B1 is “Apple”. If at least one condition is true, the formula returns “Apple Found”; otherwise, it returns “Apple Not Found”.

Press Enter: Press the Enter key to execute the formula. The cell will display the appropriate result based on the conditions.

7.4 Examples of Using AND and OR

Let’s look at a few examples to illustrate how these functions work:

Cell A1	Cell B1	Formula	Result
Apple	Inc	`=IF(AND(A1="Apple", B1="Inc"), "Yes", "No")`	Yes
Apple	Comp	`=IF(AND(A1="Apple", B1="Inc"), "Yes", "No")`	No
Apple	Comp	`=IF(OR(A1="Apple", B1="Inc"), "Yes", "No")`	Yes
Orange	Inc	`=IF(OR(A1="Apple", B1="Inc"), "Yes", "No")`	Yes
COMPARE.EDU.VN	Is Best	`=IF(AND(A1="COMPARE.EDU.VN", B1="Is Best"), "Yes", "No")`	Yes
COMPARE.EDU.VN	Great	`=IF(OR(A1="COMPARE.EDU.VN", B1="Great"), "Yes", "No")`	Yes

7.5 Combining with Other Functions

You can combine the AND and OR functions with other text comparison functions to create more complex conditions:

=IF(AND(ISNUMBER(SEARCH("apple", A1)), ISNUMBER(SEARCH("inc", A1))), "Apple Inc Found", "Not Found")

This formula checks if both “apple” and “inc” are found in cell A1.

7.6 Advantages of Using AND and OR

Multiple Criteria: Allows you to evaluate multiple conditions simultaneously.
Flexibility: Provides flexibility in defining complex comparison logic.
Combinable: Can be combined with other functions for more specific comparisons.

7.7 Limitations of Using AND and OR

Complexity: Can be more complex to use compared to simple comparisons.
Readability: Complex formulas with multiple AND and OR conditions can be difficult to read and understand.

7.8 Practical Applications of AND and OR

The use of AND and OR are useful in scenarios such as:

Filtering Data: Filtering data based on multiple criteria, such as finding customers who live in a specific city and have made a purchase in the last month.
Validating Data: Validating data entries based on multiple conditions, such as ensuring that a product code is valid and the quantity is greater than zero.
Conditional Formatting: Applying different formatting styles to cells based on multiple conditions, such as highlighting cells that contain a specific keyword and are also above a certain value.

8. Using the SUBSTITUTE Function for Text Manipulation

The SUBSTITUTE function in Excel is used to replace specific text within a string with another text. This function can be useful for normalizing text before comparison or for identifying differences by replacing one text string with an empty string.

8.1 Syntax of the SUBSTITUTE Function

The syntax for the SUBSTITUTE function is as follows:

=SUBSTITUTE(text, old_text, new_text, [instance_num])

text: The text string in which you want to replace characters.
old_text: The text you want to replace.
new_text: The text you want to replace the old_text with.
[instance_num]: (Optional) Specifies which occurrence of old_text you want to replace. If omitted, all occurrences are replaced.

8.2 How to Use the SUBSTITUTE Function

Here’s how to use the SUBSTITUTE function to manipulate text:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to manipulate.
Select a Cell: Choose an empty cell where you want the result of the manipulation to appear.
Enter the Formula: Type the SUBSTITUTE function into the selected cell, specifying the text, the text to replace, and the replacement text. For example:

=SUBSTITUTE(A1, "old", "new")

This formula will replace all occurrences of “old” with “new” in the text in cell A1.

Press Enter: Press the Enter key to execute the formula. The cell will display the manipulated text.

8.3 Examples of Using SUBSTITUTE

Let’s look at a few examples to illustrate how the SUBSTITUTE function works:

Cell A1	Formula	Result
Apple Inc	`=SUBSTITUTE(A1, "Inc", "Corp")`	Apple Corp
COMPARE.EDU.VN	`=SUBSTITUTE(A1, ".", "-")`	COMPARE-EDU-VN
Text with spaces	`=SUBSTITUTE(A1, " ", "")`	Textwithspaces
Apple Apple	`=SUBSTITUTE(A1, "Apple", "Orange", 1)`	Orange Apple

8.4 Combining with Other Functions for Comparisons

You can combine the SUBSTITUTE function with other text comparison functions to normalize text before comparison:

=IF(SUBSTITUTE(A1, " ", "")=SUBSTITUTE(B1, " ", ""), "Match", "No Match")

This formula removes spaces from both cells before comparing them, allowing you to compare text without considering spaces.

8.5 Advantages of Using SUBSTITUTE

Text Normalization: Allows you to normalize text before comparison.
Flexibility: Can be used to replace specific text with any other text.
Combinable: Can be combined with other functions for more specific comparisons.

8.6 Limitations of Using SUBSTITUTE

Complexity: Can be more complex to use compared to simple comparisons.
Case Sensitivity: The SUBSTITUTE function is case-sensitive.

8.7 Practical Applications of SUBSTITUTE

The use of SUBSTITUTE are useful in scenarios such as:

Data Cleaning: Removing unwanted characters or spaces from data entries.
Text Formatting: Reformatting text data to conform to a specific standard.
Data Transformation: Transforming data from one format to another by replacing specific elements.

9. Using the TRIM Function to Remove Extra Spaces

The TRIM function in Excel is used to remove extra spaces from text strings. It removes all spaces from text except for single spaces between words. This function is useful for cleaning up text data before comparison to ensure accurate results.

9.1 Syntax of the TRIM Function

The syntax for the TRIM function is as follows:

=TRIM(text)

text: The text string from which you want to remove extra spaces.

9.2 How to Use the TRIM Function

Here’s how to use the TRIM function to remove extra spaces from text:

Open Excel: Launch Microsoft Excel and open the worksheet containing the text you want to trim.
Select a Cell: Choose an empty cell where you want the result of the trimming to appear.
Enter the Formula: Type the TRIM function into the selected cell, specifying the text you want to trim. For example:

=TRIM(A1)

This formula will remove extra spaces from the text in cell A1.

Press Enter: Press the Enter key to execute the formula. The cell will display the trimmed text.

9.3 Examples of Using TRIM

Let’s look at a few examples to illustrate how the TRIM function works:

Cell A1	Formula	Result
Apple Inc	`=TRIM(A1)`	Apple Inc
compare.edu.vn	`=TRIM