I know how to incorporate a number from a number formatted cell into a text formatted cell, but I can't remember how to incorporate text from one cell into another text formatted cell. Here's an example of doing it with a number: ="Net weight: "&TEXT(B23,"000.00")&""
The string "Net weight" is not part of the other cell.
I want to incorporate a text string into another text formatted cell to provide information that fills in a blank in a sentence the same way I did a number as shown above. Any suggestions? I'm using Excel 2008/Mac.
