TEXT, VALUE, EXACT, CHAR and CODE Excel Practice Questions with Solutions

Introduction

Excel often needs to convert numbers into formatted text, text into numbers, compare text values, and work with character codes. The TEXT function formats numbers and dates as text, VALUE converts numeric text into numbers, EXACT checks whether two text values are exactly the same, CHAR returns a character from a code, and CODE returns the code of the first character in a text value. TEXT, VALUE, EXACT, CHAR and CODE Excel practice questions with solutions to help you understand the concepts.

Question 1: Format Numbers as Currency Using TEXT

Problem Statement

Sales amounts are stored as numbers. Display them with a rupee symbol and two decimal places.

Excel Data

Solution

In C2, enter:

=TEXT(B2,"₹#,##0.00")

Copy the formula down.

Expected Output

Note: TEXT returns the formatted result as text, not as a numeric value.

Question 2: Format Dates Using TEXT

Problem Statement

Dates are stored in Excel’s normal date format. Display them in the format:

15 September 2026

Excel Data

Solution

In C2, enter:

=TEXT(B2,"dd mmmm yyyy")

Copy down.

Expected Output

Question 3: Convert Text Numbers into Numbers Using VALUE

Problem Statement

Sales figures have been imported as text. Convert them into actual numbers so they can be used in calculations.

Excel Data

Solution

In C2, enter:

=VALUE(B2)

Copy down.

Expected Output

After conversion, the results can be used normally in mathematical calculations.

Question 4: Compare Two Text Values Using EXACT

Problem Statement

Check whether the two product codes are exactly identical, including capitalization.

Excel Data

Solution

In C2, enter:

=EXACT(A2,B2)

Copy down.

Expected Output

EXACT is case-sensitive.

Question 5: Generate Characters Using CHAR

Problem Statement

Use CHAR to generate common special characters.

Create:

• A
• B
• C
• D
• E

using their character codes.

Excel Data

Solution

In B2, enter:

=CHAR(A2)

Copy down.

Expected Output

CHAR converts a numeric character code into its corresponding character.

Question 6: Find the Character Code Using CODE

Problem Statement

Find the character code of the first character in each product code.

Excel Data

Solution

In B2, enter:

=CODE(A2)

Copy down.

Expected Output

CODE returns the numeric code of the first character in the supplied text.

Question 7: Create a Formatted Invoice Number Using TEXT

Problem Statement

Invoice numbers are stored as ordinary numbers. Display them in this format:

INV-00001

Excel Data

Solution

In B2, enter:

="INV-"&TEXT(A2,"00000")

Copy down.

Expected Output

Here, TEXT adds leading zeros to create a consistent invoice format.

Question 8: Compare Customer Names Exactly

Problem Statement

A company has two customer lists. Check whether the names match exactly, including capitalization.

Excel Data

Solution

In C2, enter:

=EXACT(A2,B2)

Copy down.

Expected Output

This is different from a normal = comparison because EXACT checks capitalization.

Question 9: Convert Imported Numeric Text and Calculate Total

Problem Statement

Product prices and quantities have been imported as text. Convert them to numbers and calculate the total value.

Excel Data

Solution

In D2, enter:

=VALUE(B2)*VALUE(C2)

Copy down.

Expected Output

VALUE converts the text values into numbers before multiplication.

Question 10: Create a Formatted Employee Code Using TEXT, CHAR and CODE

Problem Statement

Create a new employee code using:

• First letter of the employee’s name
• Employee number with three digits
• Department code

For example:

R-101-IT

Excel Data

Solution

In D2, enter:

=CHAR(CODE(LEFT(A2,1)))&"-"&TEXT(B2,"000")&"-"&C2

Copy down.

Expected Output

Here:

• LEFT gets the first character.
• CODE gets its character code.
• CHAR converts that code back to a character.
• TEXT formats the employee number with leading zeros.

Key Takeaways

• TEXT converts a number or date into formatted text.
• VALUE converts numeric text into an actual number.
• EXACT compares two text values and is case-sensitive.
• CHAR in excel converts a character code into a character.
• CODE returns the code of the first character in a text value.
• TEXT in excel is useful for creating formatted dates, currency values, invoice numbers, and IDs.
• VALUE is useful when numbers have been imported or stored as text.
• EXACT is useful when capitalization matters during text comparison.
• CHAR and CODE can be used to work with character codes.
• TEXT returns text, so its result should not be used directly for mathematical calculations unless it is converted back to a number.
• These functions become more powerful when combined with functions such as LEFT, CONCAT, IF, and other text functions.

FAQs

1. What does the TEXT function do in Excel?

TEXT converts a numeric value or date into text using a specified format.

For example:

=TEXT(A2,"₹#,##0.00")

2. Does TEXT change a number into text?

Yes. The result returned by TEXT is text, even if the original value was a number.

3. What does VALUE do in Excel?

VALUE converts text that represents a number into an actual numeric value.

=VALUE(A2)

4. What is the difference between TEXT and VALUE?

TEXT generally converts a number into formatted text, while VALUE converts numeric text back into a number.

For example:

=TEXT(25000,"₹#,##0")

returns formatted text, while:

=VALUE("25000")

returns a number.

5. Is EXACT case-sensitive?

Yes. EXACT considers uppercase and lowercase letters different.

=EXACT("Excel","excel")

returns FALSE.

6. What does CHAR do in Excel?

CHAR converts a numeric character code into its corresponding character.

=CHAR(65)

returns A.

7. What does CODE do in Excel?

CODE returns the numeric code of the first character in a text string.

=CODE("Apple")

returns the code for A.

8. Can TEXT be used to add leading zeros?

Yes. For example:

=TEXT(A2,"00000")

can turn 25 into 00025.

9. Can VALUE be used in calculations?

Yes. This is one of its main uses when numbers are stored as text.

=VALUE(A2)*VALUE(B2)

10. Why are TEXT, VALUE, EXACT, CHAR and CODE useful in Excel?

They help with formatting, data conversion, text comparison, character handling, and cleaning or standardizing imported data. These functions are especially useful when working with IDs, invoices, dates, numeric text, and structured datasets.

Written by Shubhranshu Shekhar, who has trained 20000+ students in coding.

Rishabh Kumar