|
Excel: Sounds Good
Formulas -> Text ->Concatenate Text as
well as numbers can be edited by formulas. One useful Text
function combines the data in several cells. This function also
has a cool name: concatenate. Try It:
Concatenate the Text Copy
the Original Data sheet. Name the
new sheet: Text Functions. Select
cell F1 and type the following label: Product Revenue Select
cell F2. Go to
Formulas->Text. Click on:
Concatenate. Keep
going...
|
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas
3.7. Format or modify text using formulas 3.7.1. Format text by using formulas