Question

Ms exal me kon sa text fuction h btaye

Answer 1

Answer:

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.

How do I use text function in Excel?

Combine Cells With Text and a Number

Select the cell in which you want the combined data.

Type the formula, with text inside double quotes. For example: ="Due in " & A3 & " days" NOTE: To separate the text strings from the numbers, end or begin the text string with a space.

Press Enter to complete the formula.

Convert formula to text string with User Defined Function

Hold down the Alt + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

Click Insert > Module, and paste the following macro in the Module Window. ...

In a blank cell, such as Cell D2, enter a formula =ShowF(C2).

Explanation: