Dec 15 2021 05:13 AM
Hi,
I'm using the newest version of Excel on PC.
I'm working on a huge project and need some help so I can work smarter in Excel. I have managed to combine data from four cells, but it looks messy and I want to place the text from each cell below the next one. In the picture below, you can see the formula I have used to combine the data. And in the yellow cell I have manually made the set up that I want.
Is it possible to format the cells so the combined data get the view I'm looking for?
I have tried "Alt+Enter" within the formula I made but nothing happens...
Dec 15 2021 05:27 AM
SolutionUse
=A2&CHAR(10)&"Phone: "&B2&CHAR(10)&"Email: "&C2&CHAR(10)&"Web: "&D2
CHAR(10) is the line break character in Excel.
Don't forget to turn on Wrap Text for the cell with the formula.
Dec 15 2021 05:27 AM
SolutionUse
=A2&CHAR(10)&"Phone: "&B2&CHAR(10)&"Email: "&C2&CHAR(10)&"Web: "&D2
CHAR(10) is the line break character in Excel.
Don't forget to turn on Wrap Text for the cell with the formula.