In this article we will learn about how to combine the text and formatted values in Microsoft Excel 2010.
Sometimes when we prepare analysis reports, we show the numbers with text and if we want to make any changes in the number that should be updated automatically in analysis points in Microsoft Excel 2010.
To do this we use the “&” symbol in our function. This symbol is used to add the text with calculated numbers.
Let’s take an example to understand that how we use the “&” symbol with calculated numbers.
We have a date of birth in cell A1, we want to calculate the age till today. We want the age to be automatically calculated on a daily basis. And also age should appear with the text years in cell B1.
To calculate the age we use the Today formula along with Round formula, in which today formula will work for today’s date and Round formula will round the figure which we got after the calculation of age.
To do this follow below given steps:-
Let’s understand another example, how to combine text and formatted values in a cell.
We have text and formulated value in the range A1:C3. In which A1 is containing the value 4686 and cell B1 is containing the value 125.
If you want to combine the text and value with the total value of cell A1 and B1, follow below mentioned steps:-
Note: If you will change the value in cell A1 and B1, then value will get changed automatically.
This is all about the how to combine the text with formatted values in Microsoft Excel 2010 and 2013.
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.