=TEXT(value,format_text)
value argument [Required] is used to give the text or cell reference for which formatting is to be changed
format_text [Required], is used to give the formatting code as per the requirement
Here we have some examples, where “Column A” has various values, “Column B” represents format_text and “Column C” shows the output of the function.
We will be using TEXT function as follows:
– Format of cell can also be changed by following CTRL+1 (or MAC Command button +1) and select the desired format/appearance
– If cell reference is not correctly provided in the function, then it will give output as an error
– Function should give output in “General” format, however if output is not as per the desired format then we need to change the cell format to “GENERAL”
Hope you learnt this Function,
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:
In this tutorial, we’re going to explore one of the most intriguing features in Excel: the OFFSET function.
So, what is the OFFSET function in Excel? Simply put, OFFSET gives you a reference to a range of cells that’s moved from a starting point by a certain number of rows and columns.
The tutorial teaches you the basics of regression analysis and shows a few ways to do linear regression in Excel.
Imagine this: you have a lot of data and need to predict next year’s sales for your company. You’ve found many factors that could affect the sales, maybe even hundreds. But how do you know which ones really matter? You can use regression analysis in Excel. It will help answer this and other questions, like: Which factors are important and which ones don’t matter? How connected are these factors? And how confident can you be in your predictions?”
Filter in Excel is an essential tool that helps to display relevant data. It eliminates the irrelevant entries temporarily from the view. This tool filters data according to the criteria to help analyze the critical data points
The only thing worse than wrong data in your spreadsheet is Empty Cells. If these blanks aren’t filled, they can cause problems when using formulas. I usually fill these empty cells with 0 or “NA”…
CONCATENATE function is used for combining two or more Microsoft Excel strings into one. The output of the function returns as a combined string in new cell.
ROW function is used to get the row reference number of the excel worksheet. ROW Function has only one argument i.e. reference,