Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Copy data from three cells into one divided by line break

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
nebb-sbt
Asked:
nebb-sbt
  • 2
1 Solution
 
jimyXCommented:
You have to format the cell to wrap text first.
0
 
jimyXCommented:
For cell D1 right click then go to Alignment tab -> Text Control make sure to select Wrap text.
0
 
nebb-sbtAuthor Commented:
doh, thanks :)
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now