Written by Allen Wyatt (last updated December 30, 2023)
This tip applies to Excel 97, 2000, 2002, and 2003
Excel provides a function called CONCATENATE which can be used to combine the contents of several cells, or even to combine cell contents with other text. For instance, let's say you wanted to add together the contents of cells A3 and B3, separate them by a space, and have the result appear in cell C3. All you need to do is put the following formula in cell C3:
=CONCATENATE(A3," ",B3)
Primarily, the CONCATENATE function is used for compatibility with other spreadsheet programs. You can just as easily use the ampersand (&) operator to combine text values using a formula. For instance, the following is equivalent to the example of CONCATENATE shown above:
=A3 & " " & B3
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2433) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Using the CONCATENATE Worksheet Function.
Best-Selling VBA Tutorial for Beginners Take your Excel knowledge to the next level. With a little background in VBA programming, you can go well beyond basic spreadsheets and functions. Use macros to reduce errors, save time, and integrate with other Microsoft applications. Fully updated for the latest version of Office 365. Check out Microsoft 365 Excel VBA Programming For Dummies today!
Want to repeat cell contents over and over again within a single cell? Excel provides two ways you can duplicate the content.
Discover MoreIf you've got a list of names in a column, you may want to change the order of each name. For instance, the name have the ...
Discover MoreNeed to come up with a formula for combining lots of text from various cells? Here's a full discussion on how you can do ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments