Alt+Enter
(or Command+Option+Enter
2003 coachman somerset powers manual. for Mac) to add a line break as shownbelow.A1.
A1
. This is because Excel needs to format the break and Wrap Textis the way to do it. The formula bar is immune to show any formatting, but itwill show you the data you have (in this case, some text, then a line break andsome more text after). It’s just another way to show you that you have a breakin the cell, but it’s not formatted to show it that way.CONCATENATE()
function) along with thefunction CHAR(10)
to insert the break (CHAR(13)
on Mac). The CHAR()
function takes in an integer and will show a character based on that integer. Please seeMicrosoft’s page on the CHAR() functionfor more info. The 10
(13
for Mac) in this case refers to the character“Line Feed.”B1
and add a formula to combine cells A1
and A2
with a linebreak in between them. The formula to use is: