Mohammad Layeeque
Reputation: 21
In MS Excel, concatenation of two cell such that it could appear in two line in same cell
In MS Excel, Lets cell A5 and B5 has some text. I want to concatenate these text such that it could appear in two line in same cell. Could you please provide the solution?
Upvotes: 0
Views: 46
Answers (1)
Harun24hr
Reputation: 36840
If only option is excel formula then use as following or you have to use vba code.
=A5 & CHAR(10) & B5
Enable Wrap text for the cell where you put formula. See below screenshot.
Upvotes: 2
Related Questions
- How to concat 2 cells in excel
- How can I concat cellvalues with new line in MS Excel?
- How can I concatenate multiple cells from the same column and different lines in Excel?
- How to concatenate two cells without space in excel?
- Google Sheets - Concatenate 2 rows across columns into 1 cell
- excel vba - concatenate two cell's content to another
- concatenate two columns row wise into single cell with new line
- How to merge cell in Excel in this specific way
- Excel concatenate
- How to concatenate in cell