Format number concatenated with text in Excel
For example, I want to get a summary text "Actual vs Target difference for Barbara Schmidt is $3'769" for the table below. Note the formatting for dollar value.
To do it in Excel, here is the answer:
a) Enter the formula ="Actual vs Target difference for " & C5 & " " & D5 & " is " & TEXT(I5,"$#,##0")
The last element in the formula TEXT(I5,"$#,##0") sets the format of the number found in cell I5. Even though string operation is performed on the cell, the number in the string is formatted as needed.
You can find similar Excel Questions and Answer hereunder
1) Remove the apostrophe cell text values in Excel
2) Concatenate number with text but keeping in number format in Excel
3) How to find the column number from the cell address in VBA
4) How can I find number of months that has elapsed given 2 dates?
5) How do I get the 2nd highest number in a range of numbers?
6) Converting numbers stored as text to numbers via macro in Excel
7) How to find the cell address from the column number in VBA
8) How to format variable with VBA with the very useful format function. Define the number of decimal, the way a date is formated
9) How can I set the fill color, font color and set number format of cell to date?
10) Conditional formatting with if statement in Excel