In this article, we will learn how to join two text in excel and numerically calculated result into one output string. We use the TEXT function in Microsoft Excel 2010 to get the desired output.
TEXT:- This function is used to convert a value to text in a specific number format.
Syntax of “TEXT” function: =TEXT (Value, format_text)
For Example: -
Let’s take an example to understand how we can combine cells in excel and numerically calculated results into one output string.
We want to combine the data from cells A2:C2 into a single cell and ensuring that the number in cell B2 is formatted as currency.
In this article, we use TEXT function to provide the format to number, use the “&” symbol to merge the number and text together.
We want to prepare the statement for all agents such as: - Abel scored $346 in September’2014.
Follow below given steps:-
This is the way we can combine the text and numerically calculated result into one output string in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
If you're having trouble with the formula, make sure to use straight quotes unlike the article which uses left/right double quotes.
C2 =TEXT(A2,”MMMM”)
?
C2 =TEXT(A2,"MMMM")
That's right.
thanks