How do concatenate in excel

Related functions. Email HP. Your formulas and explanation are very helpful and convenient in my understanding. I used the "network. High appreciation and regards to you guys. Excel video training Quick, clean, and to the point. Learn more. Unfortunately, you cannot put line breaks in formulae as easily as you do with punctuation marks because they are not regular characters. In this case, you should use the CHAR function.

To concatenate multiple columns, you can write a regular concatenation formula in the first cell, and then drag the fill handle to copy it to other cells. To do it quickly, you can select the cell that contains the necessary formula, and then double-click the fill handle.

Excel decides how far cells should be copied after your double click based on which cells are present in your formula. Therefore, if your table contains empty cells, you may need to drag the fill handle manually. To quickly select multiple cells, you can press Ctrl and then click on each of the cells that you want to combine. In this example, all items are also separated with designated spaces.

You can also include extra spaces after each text string to avoid typing them separately in formulae. You should also keep in mind that concatenate functions always return a text string, even if some cells contain numerical values.

You can also convert numbers to text by using the TEXT function and use different formulae to set the format of numbers that you want to combine with text or symbols. For example, if your A2 cell contains the number When concatenating values of different cells, pay attention to quotation marks and commas because they are very important for displaying the results properly.

I hope that this guide will help you save a lot of time and make your workflow as efficient as possible. This will let you control the formatting when combining text with a number or a date. Let's look at how to combine all of this information. In this worksheet, I want to record the date and time each blog post went live so I can reference the information during my monthly performance analysis. The formula needed to join these three strings may look complicated, but it's simple once you decide how to format the date and time.

The result is a text string that provides meaningful context by sharing what date and time the posts went live. Apply the function to the rest of the worksheet using the same steps as before. If you're excited about your new Excel skills, you may have the urge to jump in and organize worksheets with thousands of data points.

So you have to work in sections if you want to create hundreds or thousands of new text strings. If you need to combine a massive range of tens or hundreds of cells, try out one of these shortcuts. If you need to combine hundreds of cells, you don't want to waste time clicking on each cell. If you're new to the program, take the time to learn more about how to use Excel and check out these helpful keyboard shortcuts.

You'll be whizzing your way around worksheets and working more efficiently in no time. Originally published Jun 30, PM, updated June 30 Logo - Full Color. Contact Sales. Overview of all products. Marketing Hub Marketing automation software. Service Hub Customer service software. CMS Hub Content management system software. Operations Hub Operations software.

App Marketplace Connect your favorite apps to HubSpot. Why HubSpot? Marketing Sales Service Website. Subscribe to Our Blog Stay up to date with the latest marketing, sales, and service tips and news. Thank You! You have been subscribed.

Start free or get a demo.