This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi
I have a formula that returns me two values. I am using a '&' to use 2 formulas to get me 2 values from different cells into a single cell. The cell value that i get by using the formula is sales (numeric) and the sales person (text). Both come in the same line. I want the data to appear as a 2 line data in the same cell that is sales say 100000 and below that (sales person)
When i use Alt+enter, the formula bar shows the formula in 2 lines, but the data in the cell appears as a single line only.
Help!
Nikhil
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
=A1&CHAR(10)&B1
but be sure to format that cell as wrap text
Bob Umlas
Excel MVP