|
Listen to this post if you prefer
|
Problem: You want to merge together two separate text strings, or you want a label in your spreadsheet to be a more customized description of the numeric variables associated with that label
REFM 60-Second Skills Solution: Use the CONCATENATE and TEXT functions
Basic Example: Merge together two separate text “strings” into a single result using CONCATENATE
Merge together two text strings with the CONCATENATE function
The result.
Advanced Example: Use the TEXT function to string together multiple variables within a custom label
To create a custom label that will change when the variables change,
use the TEXT functions as shown here.
Here is the Excel file that is the source of the Advanced Example graphics above. Enjoy.
Saw this post in my RSS reader…and since it involved Excel, I had to take a look. Nice job explaining these two functions.
Thanks Chris!