ExcelBanter - How do I make a hard return within a cell in Excel?

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I make a hard return within a cell in Excel? (https://www.excelbanter.com/new-users-excel/47396-how-do-i-make-hard-return-within-cell-excel.html)

Rose49

How do I make a hard return within a cell in Excel?

Dave Peterson

Use alt-enter if typing

or char(10) in a formula

="asdf&char(10)&"qwer"

(remember that wrap text must be turned on (format|cells|alignment tab)

Rose49 wrote:

--

Dave Peterson

All times are GMT +1. The time now is 09:35 PM.