The result will look like as shown below:įor example, we have a table with time and dates in columns B and C, and we want both the values to concatenate with space as a separator in a single cell. Let us now see how to use the TEXT Function with the help of some examples. This TEXT function is very simple easy to use. In addition to this, you can include any of the below characters in the format code, and they will be displayed exactly as entered. Below is a table containing the most common and frequently used formats. Typically, the Text function accepts most of the format codes used in Excel number formats. TEXT Function Format CodesĪs we saw earlier, the formula of the Text function is very easy however, there is a tricky part to it which is supplying a format code that will output your number in a format of your choice. The TEXT function is available in all versions of Microsoft Excel. It is supplied in the form of a format code enclosed in the quotation marks, e.g. format_text (required)– a format which you want to apply. The value can be a number, date, reference to a cell containing a numeric value or any other function that returns a number or date. value (required)– the numeric value which needs to be converted to text.Excel functions, formula, charts, formatting creating excel dashboard & others
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |