Pages

Thursday, November 10, 2011

Use the TEXT function to combine and format text - Text Functions - Microsoft Excel Tutorials


Use the TEXT function to combine and format text

In a daily sales record, employee names are listed in column A and their daily sales are entered in column B. There are two tasks here: We need to determine the percentage of the weekly sales goal ($1,000) that was met by the daily sales, and we want to combine the information from columns A and B.


To combine and format text:

1. In a worksheet, copy the data shown in Figure 3-30.
2. Select cells C2:C10 and type the formula =B2/1000.
3. Press <-Ctrl+Enter->.
4. Select cells D2:D10 and type the following formula: =A2 & " sold " & TEXT(B2,"$0.00") & "today. That's " & TEXT(C2,"0.0%") & " of weekly goal.
5. Press <-Ctrl+Enter->.


Watch the Video Tutorial - https://www.youtube.com/watch?v=kgEi4_jqbdI

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews