Copy data from three cells into one divided by line break

Posted on 2011-03-17
Medium Priority
Last Modified: 2012-05-11

I want to copy text from three cells (e.g A1, B1 and C1) into D1.
Each text string should be divided by line break.

For example
A1: 1
B1: 2
C1: 3
should be shown as
inside the cell D1

I tried the formula =A1 & CHAR(10) & B1 & CHAR(10) & C1 but that didnt do the trick.
Any suggestions?
Question by:nebb-sbt
  • 2
LVL 24

Accepted Solution

jimyX earned 1000 total points
ID: 35154386
You have to format the cell to wrap text first.
LVL 24

Expert Comment

ID: 35154394
For cell D1 right click then go to Alignment tab -> Text Control make sure to select Wrap text.

Author Comment

ID: 35154397
doh, thanks :)

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question