Search Contextures Sites

Contextures Excel news by email Email: Name (optional): We respect your email privacy	Combine Cells in Excel You can combine cells in Excel -- join data from multiple cells into one cell, either "As is", or with additional text and formatting. Also, you can combine text, and the result of a function. Video: Excel Combine Text Combine Text from Multiple Cells Add Spaces to Combined Text Combine Cells With Text and a Number Combine Cells With Text and a Formatted Date TEXT Function Formatting Examples More Function Tutorials Video: Excel Combine Text Watch this short Excel video tutorial to see the steps for combining text and formatting the results.   Combine Text from Multiple Cells To combine text from multiple cells into one cell, use the & (ampersand) operator. Select the cell in which you want the combined data Type an = (equal sign) to start the formula Click on the first cell Type the & operator (shift + 7) Click on the second cell Press Enter to complete the formula Add Spaces to Combined Text When you combine cells with text using the above formula, there is no space between the first and last names. To insert a space, you can include a text string in the formula. Select the cell in which you want the combined data Type an = (equal sign) to start the formula Click on the first cell Type the & operator Type " " (double quote, space, double quote) Type the & operator Click on the second cell Press Enter to complete the formula Combine Cells With Text and a Number You can combine cells to join a text string with a number from a cell. In this example, text will be added to the payment terms. Select the cell in which you want the combined data Type the formula, with text inside double quotes. For example: ="Due in " & B3 & " days" Note: To separate the text strings from the numbers, end or begin the text string with a space. Press Enter to complete the formula Combine Cells With Text and a Formatted Date When you combine text with a date, you can format it by using the Text function. Without formatting, the date will appear as a number.     Date without formatting       Date with formatting Select the cell in which you want the combined data Type the formula, with text inside double quotes, and the date inside the TEXT function. For example: ="Today is " & TEXT(TODAY(),"dddd") In the TEXT function, the date is the first argument, and the formatting is the second argument. In this example, the TODAY function returns the current date. The "dddd" formats the date as the full weekday name. Press Enter to complete the formula TEXT Function Formatting Examples Here are a few examples of using the TEXT function to format numbers. Format a date as 12/31/04:   ="Payment is due " & TEXT(A2,"mm/dd/yyyy") Format a number as currency:   ="Amount due: " & TEXT(A3,"$#,##0.00")& " USD" Format a number as a percentage:    ="Your score is " & TEXT(A4,"0.00%") Format a number as a fraction:    ="Hours worked: " &TEXT(A5,"# ?/?") More Function Tutorials Sum Functions -- Sum Cells   VLOOKUP Function   INDEX / MATCH Functions   Count Functions -- Count Cells   INDIRECT Function

Home     Excel Tips     Excel Files     The Excel Store     Blog     Contact
Privacy Policy		Contextures Inc., Copyright ©2013 All rights reserved.	Debra Dalgleish

Last updated: March 21, 2013 3:08 PM