Solved

Copy data from three cells into one divided by line break

Posted on 2011-03-17
3
227 Views
Last Modified: 2012-05-11
Hi,

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
1
2
3
inside the cell D1

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

Accepted Solution

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

Expert Comment

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

Author Comment

by:nebb-sbt
ID: 35154397
doh, thanks :)
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 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