Question

explain any three text functions in excel​

Answer 1

Answer:

1 Count and Sum: The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.

1 Count and Sum: The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.2 Logical: Learn how to use Excel's logical functions such as the IF, AND, OR and NOT function.

1 Count and Sum: The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.2 Logical: Learn how to use Excel's logical functions such as the IF, AND, OR and NOT function.3 Cell References: Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.

1 Count and Sum: The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.2 Logical: Learn how to use Excel's logical functions such as the IF, AND, OR and NOT function.3 Cell References: Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.4 Date & Time: To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon). You can also enter a date and a time in one cell.

1 Count and Sum: The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.2 Logical: Learn how to use Excel's logical functions such as the IF, AND, OR and NOT function.3 Cell References: Cell references in Excel are very important. Understand the difference between relative, absolute and mixed reference, and you are on your way to success.4 Date & Time: To enter a date in Excel, use the "/" or "-" characters. To enter a time, use the ":" (colon). You can also enter a date and a time in one cell.5 Text: Excel has many functions to offer when it comes to manipulating text strings.

I have given u 5 functions of excel u can choose any 3 of them

Answer 2

Menu

TEXT Function

Convert numbers into text in a spreadsheet

Home › Resources › Excel Resources › Functions › TEXT Function

What is the Excel TEXT Function?

The Excel TEXT Function is used to convert numbers to text within a spreadsheet. Essentially, the function will convert a numeric value into a text string. TEXT is available in all versions of Excel.

Formula

=Text(Value, format_text)

Where:

Value is the numerical value that we need to convert to text

Format_text is the format we want to apply

When is the Excel TEXT Function required?

We use the TEXT function in the following circumstances:

When we want to display dates in a specified format

When we wish to display numbers in a specified format or in a more legible way

When we wish to combine numbers with text or characters

Examples

1. Basic example – Excel Text Function

With the following data, I need to convert the data to “d mmmm, yyyy” format. When we insert the text function, the result would look as follows:

Text Function in Excel

2. Using Excel TEXT with other functions

We use the old price and the discount given in cells A5 and B5. The quantity is given in C5. We wish to show some text along with the calculations. We wish to display the information as follows:

The final price is $xxx

Where xxx would be the price in $ terms.

For this, we can use the formula:

=”The final price is “&TEXT(A5*B5*C5, “$###,###.00”)

Excel TEXT Function - Other Functions

The other way to do it by using the CONCATENATE function as shown below:

Excel TEXT Function - CONCATENATE

3. Combining the text given with data using TEXT function

When I use the date formula, I would get the result below:

TEXT Function - DATE

Now, if we try to combine today’s date using CONCATENATE, Excel would give a weird result as shown below:

TEXT Function - CONCATENATE Error

What happened here was that dates that are stored as numbers by Excel were returned as numbers when the CONCATENATE function is used.

How to fix it?

To fix it, we need to use the Excel TEXT function. The formula to be used would be:

TEXT Function - Fixed

4. Adding zeros before numbers with variable lengths

We all know any zero’s added before numbers are automatically removed by Excel. However, if we need to keep those zeros then the TEXT function comes handy. Let’s see an example to understand how to use this function.

We are given a 9-digit product code, but Excel removed the zeros before it. We can use TEXT as shown below and convert the product code into a 9-digit number:

TEXT Function - Variable Number Lengths

In the above formula, we are given the format code containing 9-digit zeros, where the number of zeros is equal to the number of digits we wish to display.

5. Converting telephone numbers to a specific format

If we wish to do the same for telephone numbers, it would involve the use of dashes and parentheses in format codes.

Here, I want to ensure the country code comes in brackets (). Hence the formula used is (##) ### ### ###. The # is the number of digits we wish to use