Say, you have a list of names in column A and a list of each person’s income in column B, and in column C you want to create a sentence like “John Brown earns $2,800.00 per month“. You can use this formula in column C:
=CONCATENATE($A8,” earns “,$B8,” per month”)
However, the result would be
John Brown earns 2800 per month.
In order to format the number in your text string you can nest the TEXT() function within the CONCATENATE() function like this:
=CONCATENATE($A8,” earns “,TEXT($B8, “$#,##0.00″),” per month”)
Now the result will be
John Brown earns $2,800.00 per month.